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

134 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
unmoors94590(None) 
unmoor836311unmoor_
indoors838552indoors
moors74923142__moors
undoers82910572undoers
unhoods1137502unhoods
unhooks1436412unhooks
unmolds10135742unmolds
unmoored1137332unmoored
unroofs1035782unroofs
unroots738562unroots
amours83512643_amours
anchors123912953anchors
armors85017813arm_ors
armours9389843armours
boors74325013__boors
doors65022133__doors
enamors939123enamors
enamours1044653enamours
enroots738713enroots
floors94112353_floors
functors1335743functors
gnomons1035753gnomons
gunrooms1144323gunrooms
humors11129633hum_ors
humours1286413humours
indoor738403indoor_
inpours936413inpours
juniors1475783jun_iors
memoirs1136803memoirs
moods85224623__moods
mools76027173__mools
moons75331003__moons
moor66628553__moor_
moory105115793__moory
moos66051303__moo_s
moots75831663__moots
mors65950063__m_ors
motors84616593__motors
noirs55615463_n_oirs
nomos75919743_nomo_s
nooks95420393_n_ooks
noons54125283_n_oons
numbers113711243numbers
outdoors936423outdoors
pandoors11258983pandoors
pulmotors1342803pulmotors
rumors81110393rum_ors
rumours976363rumours
santoors837633santoors
simooms1135573simooms
simoons937933simoons
snoods74312443sn_oods
snooks104412823sn_ooks
snools65715873sn_ools
snoops84314163sn_oops
snoots64216663sn_oots
spoors84014023_spoors
sunroofs1144763sunroofs
sunrooms1045723sunrooms
tandoors9258043tandoors
tumors8810603tum_ors
tumours976733tumours
umbers104215213u_mbers
umbos94613073u_mbo_s
unbars82113033un_bars
unbears998043unbears
unbolts9247803unbolts
unborn83310813un_born
unbosoms1243253unbosoms
unboxes16208303unboxes
unclogs1036803unclogs
uncocks1537233uncocks
uncoils979533uncoils
uncool8610113uncoo_l
uncork1239043un_cork
uncorks1337443uncorks
uncos74117033un_co_s
uncovers1336573uncovers
uncross938193uncross
undocks1436163undocks
undoer73113043undoer_
undoes73917403un_does
unfolds11146803unfolds
unhairs1036373unhairs
unhood1039233unhoo_d
unhook1347523unhoo_k
unhorse1038583un_horse
unicorn946513unicorn
unicorns1044763unicorns
uniform1247053uniform
uniforms1355033uniforms
unions64216753un_ions
unipods1095703unipods
unisons748423unisons
uniters73814173uniters
unknots1144303unknots
unloads8278523unloads
unlocks1337063unlocks
unloose797863unloose
unlooses8127293unlooses
unmakers14256653unmakers
unmakes132810793unmakes
unmans82211993unm_ans
unmasks1344553unmasks
unmerry1245023unmerry
unmews11326523unm_ews
unmiters1037073unmiters
unmitre936993unmitre
unmitres1036863unmitres
unmixes16197753unmixes
unmodish1443913unmodish
unmold9148313unm_old
unmooring1255813unmooring
unmoral948693unmoral
unmoved13248903unmoved
unmown11296093unm_own
unrobes9269733unrobes
unrolls797793unrolls
unroof9410193unroo_f
unroot6315553unroo_t
unshorn1036943unshorn
unspools1043693unspools
unstops936983unstops
unswore1039053unswore
unsworn1046843unsworn
untorn63012343un_torn
unwooed11229773unwooed
unworn93411333un_worn
unyokes1466733unyokes
uproars986453uproars
uproots937143uproots
upsoars985413upsoars
utmosts934593utmosts

Search took 7 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.1401276364.3
2DLD Change Limit1340271346.36021073.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911346.54627297.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.