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 “unroofs” 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
unroofs103578(None) 
sunroofs1144761sunroofs
unroof9410191unroof_
unroots738561unroots
enroots738712enroots
gunrooms1144322gunrooms
proofs114511682_proofs
reroofs1037942reroofs
roofs85321152__roofs
sunroof1047052sunroof_
sunrooms1045722sunrooms
unhoods1137502unhoods
unhooks1436412unhooks
unmoors945902unmoors
unrobes9269732unrobes
unrolls797792unrolls
unroofed12106772unroofed
unroot6315552unroo_t
uproots937142uproots
broods95416383_broods
brooks125813883_brooks
brooms104915873_brooms
broos75126413_broo_s
coofs105924713__coofs
crooks124914413_crooks
croons85418423_croons
drools74412813_drools
droops95110963_droops
enrobes92211113enrobes
enrolls7108093enrolls
enrols61213383enr_ols
enroot6615993enroo_t
goofs94821003__goofs
grooms94512523_grooms
gunroom1045053gunroo_m
hoofs115721043__hoofs
indoors838553indoors
inroads837043inroads
karoos102415803karoo_s
kloofs13386353_kloofs
kroons103711243_kroons
loofs85623783__loofs
maroons92615553maroons
moonroofs1443253moonroofs
mudrooms1344083mudrooms
nooks95420393_n_ooks
noons54125283_n_oons
outroots839873outroots
poofs105222793__poofs
profs105120893_pr_ofs
proof105221533_proof_
reproofs1346063reproofs
reroof9315003reroof_
rolfs84817123__rolfs
roods65125283__roods
roof75738833__roof_
rooks95325043__rooks
rooms75324683__rooms
roots55933673__roots
runoffs1343013run_offs
scroops11288253scroops
shroffs1634363shroffs
snoods74312453sn_oods
snooks104412833sn_ooks
snools65715883sn_ools
snoops84314173sn_oops
snoots64216683sn_oots
spoofs114011813_spoofs
sunproof1344603sunproof_
sunroom947013sunroo_m
troops85712783_troops
turnoffs1442833turnoffs
unbolts9247803unbolts
unbosoms1243263unbosoms
unboxes16208303unboxes
unclogs1036803unclogs
uncocks1537233uncocks
uncoils979533uncoils
uncool8610113uncoo_l
uncorks1337443uncorks
uncos74117033un_co_s
uncross938193uncross
uncrowns1344363uncrowns
uncuffs1543143uncuffs
undocks1436163undocks
undoers82910583undoers
undoes73917403un_does
unfolds11146803unfolds
unfrocks1753843unfrocks
unhood1039233unhoo_d
unhook1347523unhoo_k
unions64216753un_ions
unipods1095703unipods
unisons748423unisons
unknots1144303unknots
unloads8278523unloads
unlocks1337063unlocks
unloose797863unloose
unlooses8127293unlooses
unmolds10135743unmolds
unmoor836313unmoo_r
unreels7258313unreels
unrests7229463unrests
unrigs7159003unr_igs
unrips8199453unr_ips
unrobe82611673unr_obe
unrobed102711213unrobed
unroll61210073unr_oll
unroofing1385703unroofing
unrooted9810513unrooted
unroped102812103unroped
unrough11105233unrough
unround8138503unround
unrounds9145573unrounds
unrove92511683unr_ove
unroven10238143unroven
unspools1043693unspools
unstops936993unstops
unwooed11229773unwooed
unyokes1466733unyokes
uproars986453uproars
uproot8314123uproo_t
uropods1035873u_ropods
varooms1248883varooms
vrooms11398713_vrooms
whoofs15457243_whoofs
woofs114918003__woofs

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.623286823.4
2DLD Change Limit1340271277.25018486.5
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.91922564.8
 
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.