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

127 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
outposts103725(None) 
outports1048271outports
outpost9612441outpost_
outboasts1144762outboasts
outcasts10108682outcasts
outfasts11117232outfasts
outfoots1136882outfoots
outlasts8108712outlasts
outmost9511212outmost_
outpass939712outpas_s
outplots1086362outplots
outpoints1145702outpoints
outpolls1046212outpolls
outport9714122outport_
outpours1036682outpours
outputs988492outp_uts
outroots839872outroots
utmosts934592_utmosts
airposts1045923airposts
autists73814853aut_ists
bedposts1343873bedposts
composts144210913composts
cutouts938033cut_outs
doorposts1272993doorposts
gateposts1243103gateposts
goalposts1252163goalposts
imposts11269003_imposts
jetports1743533jetports
lutists73810273lut_ists
obtests9136233obt_ests
opposes1149243o_pposes
orthoses11311133orthoses
orthosis1148193orthosis
osteoses839033osteoses
osteosis846743osteosis
ostoses71213553ost_oses
ostosis71310123ost_osis
ousts55225703ou___sts
outacts9310213out_acts
outasks1138173out_asks
outboast1048543outboast_
outboxes1737823outboxes
outbursts1143693outbursts
outcast91013743outcast_
outcaste10119613outcaste
outcastes11118903outcastes
outcomes1239763outcomes
outcooks1436723outcooks
outcounts1144793outcounts
outcross1036823outcros_s
outdoers937513outdoers
outdoes8313123outdo_es
outdoors936433outdoors
outeats72215703out_eats
outfast101412123outfast_
outfeasts12114333outfeasts
outfits102210833out_fits
outfloats1243573outfloats
outfools1136533outfools
outfoot10411493outfoot_
outfoxes1836743outfoxes
outgoes8312643outgo_es
outgross936423outgros_s
outhits102213503out_hits
outhouses12310663outhouses
outhowls1445723outhowls
outhunts1136033outhunts
outjuts1476483out_juts
outkiss1137783outkis_s
outlast71015443outlast_
outlets73616363out_lets
outlooks1236793outlooks
outloves11249673outloves
outmodes11208963outmodes
outmoves13228173outmoves
outpaces122411943outpaces
outpaints1145283outpaints
outpasses1146613outpasses
outpity1237493outp_ity
outplans10259533outplans
outplays13246843outplays
outplods11105613outplods
outplot9109483outplot_
outpoint10311513outpoint
outpoll946793outpo_ll
outpour937423outpo_ur
outpower1336673outpower
outpowers1445193outpowers
outprays13236933outprays
outpress10118183outpress
outpulls1065443outpulls
outpush1245493outpus_h
outpushes1445253outpushes
output8712853outp_ut_
outroars838923outroars
outrocks1437903outrocks
outrolls847823outrolls
outroot7516563outroot_
outrows10311403outro_ws
outserts8309803outserts
outsets73514923out_sets
outshoots1245393outshoots
outshouts1245213outshouts
outsits73215253out_sits
outsoars838853outsoars
outsoles8813113outsoles
outtasks1235633outtasks
outtrots838373outtrots
outvote1038803outvo_te
outvotes1137903outvotes
outwaits1137493outwaits
outwaste11147943outwaste
outwastes12127693outwastes
outwits103110863out_wits
outworks15148973outworks
oviposits14503733oviposits
postposes1348193postposes
posts75228783___posts
purports1265783purports
purposes1237823purposes
putouts937083put_outs
riposts9279403_riposts
supports1246513supports
supposes1238203supposes
uptoss836093_uptos_s
utmost878483_utmost_
utopists1045773_utopists

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.1701051123.5
2DLD Change Limit1461621277.26620115.9
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.49923828.6
 
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.