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

160 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
runovers113447(None) 
runover1034661runover_
cutovers1335122cutovers
recovers133511122recovers
removers13449222removers
rovers95423522r__overs
runners74212452run_ners
turnovers1243282turnovers
uncovers1336572_uncovers
allovers1137673allovers
annoyers1185033annoyers
brunchers16296253brunchers
bundlers11399183bundlers
bunglers11398483bunglers
bunkers133715953bun_kers
bunters94717123bun_ters
canoers94318373cano_ers
clovers125114663_clovers
covers114627963__covers
crunchers16316243crunchers
crunodes1144973crunode_s
culvers12329833cu_lvers
cunners93913473cun_ners
cutover1235283cutover_
drovers115212643_drovers
dunkers123512193dun_kers
estovers1136453estovers
flyovers1733673flyovers
funders113813943fun_ders
funkers143712063fun_kers
glovers114310883_glovers
groovers12337123groovers
grungers10298503grun_gers
grunters9359043grun_ters
gunners83111733gun_ners
handovers16136183handovers
hangovers16144163hangovers
honorers1139273honorers
hoovers134312713_hoovers
hovers124320253__hovers
hungers114013303hun_gers
hungover15133123hungover_
hunkers143314333hun_kers
hunters103915733hun_ters
ignorers9215243ignorers
ionomers1038503ionomers
junipers1733933junipers
junkers184010863jun_kers
knowers1436353_knowers
layovers1434073layovers
lovers94223433__lovers
lunchers13349563lunchers
lungers83817103lun_gers
lunkers113414613lun_kers
minivers1337483minivers
monomers12311033monomers
movers115117193__movers
munchers15318773munchers
munsters104010553munsters
noters64021003__noters
novels95512503__novels
overs85224793___overs
plovers123611833_plovers
popovers1595663popovers
provers123817793_provers
pruners93710733prun__ers
pullovers14124243pullovers
punchers152610073punchers
punkers133714863pun_kers
punners94114243pun_ners
punsters103310583punsters
punters93617053pun_ters
pushovers1743003pushovers
quavers19309023qu_avers
quivers19298753qu_ivers
quoters16369273qu_oters
ranchers133311793ranchers
rangers83621043ran_gers
rankers113217463ran_kers
ransomers1146873ransomers
ranters73323643ran_ters
ravers94628183r__avers
reavers108320743r_eavers
recover124312623recover_
recovery16366213recovery
reivers105117083r_eivers
remover124612273remover_
removes124514713remove_s
renders83821673ren_ders
renegers9248793renegers
renewers11238183renewers
renters74224823ren_ters
rentiers83311763rentiers
reposers102911603reposers
repowers13288533repowers
reprovers14217773reprovers
resolvers12297833resolvers
reuniters936423reuniters
revers94529633r__evers
revivers14389643revivers
revokers15366753revokers
revolvers15286113revolvers
rievers104311453r_ievers
ringers83922953rin_gers
rinsers73815743rin_sers
rioters73615523r_ioters
rivers94626543r__ivers
rogers74517913r__ogers
rollovers1244093rollovers
roofers105013903r_oofers
roomers95416413r_oomers
roosers74217883r_oosers
rooters74522933r_ooters
ropers84325903r__opers
rounders92613703roun_ders
rover85527373r__over_
roves84834483r__ove_s
rowers94924573r__owers
rubbers113913193ru_bbers
rudders93210653ru_dders
ruers515019413ru___ers
rufflers14347193rufflers
ruggers94612313ru_ggers
ruiners74213023ru_iners
rulers64317093ru__lers
rumblers123610743rumblers
rummers113513653ru_mmers
rumors81110403rumo__rs
rumours976373rumo_urs
rundles83214713rundle_s
rundlets9307363rundlets
runes55530223run__e_s
rungless956733rungless
runkles114111943runkle_s
runless72810423run_less
runlets73310773run_lets
runnels7329163run_nels
runner63814463run_ner_
runnier74010113runnier_
runoffs1343013runo_ffs
runouts737353runo_uts
runtier73512853runtier_
rushers103816103ru_shers
rustlers8339853rustlers
shovers134613003_shovers
snorers74313803_snorers
stovers103713733_stovers
sunders84120063sun_ders
tenoners858713tenoners
trovers103713323_trovers
trundlers10215003trundlers
tuners64417343tun__ers
turnover1143593turnover_
tutoyers1133303tutoyers
uncover1239003_uncover_
undoers82910583_undoers
uniters73814173_uniters
universe1145253_universe
venomers1336703venomers
wingovers1643553wingovers

Search took 9 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.453394461.4
2DLD Change Limit1461621607.82618676.5
3Display Results1601600.0632539.7
 (SQL Overall)1786911608.34221420.6
 
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.