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

113 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
outplots108636(None) 
outplods11105611outplods
outplot9109481outplot_
outfloats1243572outfloats
outflows1445462outflows
outfoots1136882outfoots
outglows1244932outglows
outlets73616362out_lets
outplans10259532outplans
outplays13246842outplays
outplod10106342outplo_d
outpolls1046212outpolls
outports1048272outports
outpost9612442outp_ost
outposts1037252outposts
outputs988492outp_uts
outroots839872outroots
outtrots838372outtrots
subplots1255772subplots
autopilots1252993autopilots
complots1438163complots
coplots11511593_coplots
couplets12389873cou_plets
cutlets94113653cut_lets
marplots1245633marplots
matelots1047533matelots
nutlets74111253nut_lets
ocelots977233o_celots
octuplets1342223octuplets
outacts9310213out_acts
outbleats1144393outbleats
outbless1037963outbless
outbloom1244003outbloom
outblooms1342973outblooms
outcasts10108683outcasts
outclass1037203outclass
outclomb1443053outclomb
outcooks1436723outcooks
outcrops1246853outcrops
outcross1036823outcross
outcrows1346653outcrows
outdoes8313123out_does
outdoors936433outdoors
outdrops1136543outdrops
outeats72215703out_eats
outfasts11117233outfasts
outfits102210833out_fits
outflies11310153outflies
outfloat1146243outfloat
outflow1355353outflo_w
outflown1464063outflown
outfools1136533outfools
outfoot10411493outfoot_
outglow1154863outglo_w
outgoes8312643out_goes
outgross936423outgross
outgrows1236283outgrows
outhits102213503out_hits
outhunts1136033outhunts
outjuts1476493out_juts
outlast71015443out_last
outlasts8108713outlasts
outlaws10249603out_laws
outlays102610903out_lays
outlet63728683out_let_
outlies72421993out_lies
outlook1138023out_look
outlooks1236793outlooks
outlove102410243out_love
outloves11249673out_loves
outmost9511213out_most
outpaces122411943outpaces
outpaints1145283outpaints
outpass939713outp_ass
outpity1237493outp_ity
outplace1257913outplace
outplaces1347743outplaces
outplan9249443outpl_an
outplay12267723outpl_ay
outplotted1343193outplotted
outpoints1145703outpoints
outpoll946793outp_oll
outport9714123outp_ort
outpour937423outp_our
outpours1036683outpours
outprays13236933outprays
outpress10118183outpress
outpulls1065443outpulls
output8712853outp_ut_
outquote1775293outquote
outquotes1874513outquotes
outrolls847823outrolls
outroot7516563outroot_
outrows10311403out_rows
outserts8309803outserts
outsets73514923out_sets
outshoots1245393outshoots
outshot10312103outshot_
outshouts1245213outshouts
outsits73215253out_sits
outsoles8813113outsoles
outtrot7312613outtrot_
outvote1038803out_vote
outvotes1137903out_votes
outwaits1137493outwaits
outwits103110863out_wits
outwrote1137723outwrote
overplots1436953overplots
plots75025673___plots
putlogs1065083put_logs
replots93412633_replots
sublots92410913su_blots
subplot1158133subplot_

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.423422437.4
2DLD Change Limit1461621137.46619577.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.93522519.3
 
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.