Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “outlearn” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
outlearn83643(None) 
outearn7310681out_earn
outlearns944631outlearns
outlearnt945961outlearnt
outearns838402out_earns
outhear10910602outhear_
outheard1288542outheard
outhears11810392outhears
outlain71212612outl_ain
outlead83311102outlea_d
outleads9278762outleads
outleap9298292outlea_p
outleaps10237072outleaps
outleapt10318152outleapt
outlearned1143622outlearned
outwear1097712outwear_
outwears1197262outwears
outweary1485392outweary
unlearn735952_unlearn
butler84220033butle_r_
butlers94518053butle_rs
butlery12369423butle_ry
cutler84718033cutle_r_
cutlers94217003cutle_rs
cutlery12448393cutle_ry
learn55322663___learn
luthern1037653luthe_rn
mislearn1045343mislearn
nuclear936233nuclear_
ostler63312193ostle_r_
ostlers72911203ostle_rs
outbark1339453out_bark
outbeam1137973outbea_m
outbeams1236063outbeams
outbleat1048423outblea_t
outbleats1144393outbleats
outboard1138323outboard
outburn936903out_burn
outcharm1544733outcharm
outdare83113403out_dare
outdrawn1245013outdrawn
outearned1056683out_earned
outeat62824533out_ea_t
outeaten8310423out_eaten
outeats72215703out_eats
outer55633303out_e_r_
outers64230173out_e_rs
outfawn1335983out_fawn
outfeast11107503outfeast
outgain81010743out_gain
outglare937383outglare
outgleam1153633outglea_m
outgleams1242603outgleams
outgnawn12122933outgnawn
outhearing1438443outhearing
outlaid81110653outl_aid
outland81212343outl_and
outlast71015443outl_ast
outlaw9279643outl_a_w
outlawry1443023outlawry
outlaws10249603outl_aws
outlay92711793outl_a_y
outlays102610903outl_ays
outleading1237133outleading
outleaped1246173outleaped
outleaping1346203outleaping
outlearning1243543outlearning
outled74020343outle__d
outlet63728683outle__t
outlets73616363outle_ts
outlier72216143outlier_
outliers82610673outliers
outman83115033out_ma_n
outplan9249443outpla_n
outran63218893out_ra_n
outreach1346003outreach
outread82811093outrea_d
outreads9289003outreads
outreason943433outreason
outroar739513outroar_
outroars838923outroars
outscorn10166143outscorn
outseen72712333outse_en
outsert72819513outse_rt
outsmart10168923outsmart
outsoar739493outsoar_
outsoars838853outsoars
outspan938743outspa_n
outstare81410693outstare
outstart81611283outstart
outsware11168843outsware
outswear1144793outswear_
outswears1244303outswears
outsworn11166663outsworn
outturn737123out_turn
outwar91011513out_war_
outward11811403out_ward
outwars10912793out_wars
outwearing1437183outwearing
outworn101610753out_worn
overlearn1235903overlearn
relearn747973_relearn
southern11438913southe_rn
sutler63718393sutle_r_
sutlers73116973sutle_rs
tutelar735373tutelar_
tutelars844993tutelars
tutelary1143573tutelary
unlearns844453_unlearns
unlearnt846403_unlearnt

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.440406115.9
2DLD Change Limit1461621107.03020791.2
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.