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 “outflew” 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.

146 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
outflew133642(None) 
outflow1355351outflow
outdrew1137142outdrew
outfeel1037542outfeel
outfelt10310602outfelt
outflies11310152outflies
outflown1464062outflown
outflows1445462outflows
outfly1238272outfl_y
outglow1154862outglow
outgrew1136712outgrew
outlaw9279642out_law
outled74020342out_led
outlet63728682out_let
butle75023103but_le_
butled94818603but_led
butler84220033but_ler
butles84423913but_les
curfew14426743curf_ew
curlew114010903cu_rlew
cutler84718033cut_ler
cutlet84924363cut_let
cuttle84113893cuttle_
cuttled10319933cuttled
cuttles93613923cuttles
duffle13368533duffle_
duffles14308923duffles
flew105824253___flew
futile93914953futile_
guttle74111973guttle_
guttled9378993guttled
guttler8369163guttler
guttles83011933guttles
mudflow1642343mudflow
muffle14339643muffle_
muffled16377783muffled
muffler15398343muffler
muffles153910453muffles
mutule8311423mutule_
mutules9311843mutules
nutlet64220563nut_let
ostler63312193ost_ler
outage72017533outage_
outages82317323outages
outate62923403outate_
outbeg938733out_beg
outbleat1048423outbleat
outbless1037963outbless
outbred10311263outbred
outbye1147913outbye_
outcrow1246343outcrow
outdoer849273outdoer
outdoes8313123outdoes
outdraw1136903outdraw
outduel837303outduel
outed65429063out__ed
outer55633303out__er
outfable1378813outfable_
outfabled1595093outfabled
outfables1485563outfables
outface123011973outface
outfaced14219463outfaced
outfaces132311393outfaces
outfall1039683outfall
outfalls1138143outfalls
outfast101412123outfast
outfawn1335983outfawn
outfeels1135063outfeels
outfield1265253outfield
outfind1139563outfind
outfire1049713outfire
outfired1238083outfired
outfires1139863outfires
outfish132210573outfish
outfit93014953outf_it
outfits102210833outfits
outflank1544593outflank
outfloat1146243outfloat
outflowed1665063outflowed
outfool1037333outfool
outfooled1345493outfooled
outfoot10411493outfoot
outfox1636143outf_ox
outfoxed1936013outfoxed
outfoxes1836743outfoxes
outfrown1444863outfrown
outgleam1153633outgleam
outglows1244933outglows
outgnaw11124353outgnaw
outgoes8312643outgoes
outgrow1136323outgrow
outkeep1345673outkeep
outlaws10249603out_laws
outlay92711793out_lay
outlead83311103out_lead
outleap9298293out_leap
outlets73616363out_lets
outlie62419533out_lie
outlier72216143outlier
outlies72421993outlies
outplan9249443outplan
outplay12267723outplay
outplod10106343outplod
outplot9109483outplot
outre53922203out_re_
outrow9311183out_row
outsaw92610283out_saw
outsee63121803out_see
outseen72712333outseen
outsees72616433outsees
outsell7109263outsell
outset64027453out_set
outsleep1046013outsleep
outslept1047703outslept
outsole71013433outsole_
outsoles8813113outsoles
outsped101110323outsped
outtell797883outtell
outthrew14123973outthrew
outvie92412803outvie_
outvied11239693outvied
outvies102214243outvies
outweep1236673outweep
outwile10310263outwile_
outwiled1237603outwiled
outwiles1139233outwiles
outyell1095843outyell
outyelp1294323outyelp
overflew1735593overflew
purfle112511183purfle_
purfled13248733purfled
purfler12248733purfler
purfles122511853purfles
reflew12389453_reflew
ruffle124111673ruffle_
ruffled14369153ruffled
ruffler13369723ruffler
ruffles133512273ruffles
rutile65217683rutile_
rutiles74315843rutiles
souffle13306803souffle_
souffled15276193souffled
souffles14298123souffles
sutler63718393sut_ler
upflow1433523_upflow
utile54718933_utile_

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271467.30018359.9
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.76623009.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.