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

210 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
runover103466(None) 
runovers1134471runovers
cutover1235282cutover
hungover15133122hungover
recover124312622recover
remover124612272remover
rover85527372r__over
runner63814462run_ner
runnier74010112runnier
runtier73512852runtier
turnover1143592turnover
uncover1239002_uncover
allover1038583allover
annoyer1095603annoyer
bruncher15347783bruncher
bundler104011723bundler
bungler104611483bungler
bunker124519373bun_ker
bunter85020383bun_ter
buxomer1833243buxomer
canoer85121073cano_er
clover114617123_clover
cover105430773__cover
cruncher15338073cruncher
crunode1034713crunode_
crunodes1144973crunodes
culver113010633cu_lver
cunner83915003cun_ner
cutovers1335123cutovers
drover104614593_drover
drunker12326633drun_ker
dungier9368583dungier
dunker113616463dun_ker
dunner73913823dun_ner
flyover1633513flyover
funder104016083fun_der
funker133915763fun_ker
funkier14349983funkier
funner93414103fun_ner
funnier103210173funnier
glover104513533_glover
groover11358543groover
grunger9389783grun_ger
grungier1034983grungier
grunter83110783grun_ter
gunkier12369553gunkier
gunner73813983gun_ner
handover15126823handover
hangover15134433hangover
honorer1039673honorer
hoover124314433_hoover
hover115524133__hover
hunger104015203hun_ger
hunker133917673hun_ker
hunkier144512143hunkier
hunter94817773hun_ter
ignorer8276103ignorer
ionomer939833ionomer
juniper1634023juniper
junker174213653jun_ker
junkier18339493junkier
knower1337083_knower
layover1334433layover
lover85526453__lover
luncher123111413luncher
lunger75720423lun_ger
lunier64617603lun_ier
lunker104718343lun_ker
miniver1238393miniver
monomer11311893monomer
mover104220863__mover
muncher143610373muncher
munster93710523munster
never86218643__never
noter55025643__noter
novel85615993__novel
over77227343___over
plover115312613_plover
popover1495843popover
prover113819723_prover
pruner83413453prun__er
pullover13134643pullover
puncher143311673puncher
punier84519223pun_ier
punker123718823pun_ker
punkier133512793punkier
punner84918153pun_ner
punnier93511263punnier
punster92911103punster
punter84320023pun_ter
pushover1643083pushover
quaver18309313qu_aver
quiver18278743qu_iver
quoter153510093qu_oter
rancher123013633rancher
randier83618473randier
ranger73925533ran_ger
rangier83714353rangier
ranker105021903ran_ker
ransomer1047883ransomer
ranter63826823ran_ter
raver85631493r__aver
reaver94524733r_eaver
recovers133511123recovers
recovery16366213recovery
reiver95318293r_eiver
remoter94815973remoter
remove116115573remove_
removed134611313removed
removers13449223removers
removes124514713removes
render74024143ren_der
reneger8299493reneger
renewer10248693renewer
renter64527413ren_ter
rentier73618223rentier
reposer93715333reposer
repower12329883repower
reprover13229203reprover
resolver11339793resolver
reuniter838323reuniter
reviver134411373reviver
revoker14419193revoker
revolver14287713revolver
rewove126420083rewove_
rewoven13557933rewoven
riever94811653r_iever
ringer74526063rin_ger
rinser64317213rin_ser
rioter64817283r_ioter
river85731693r__iver
roger64521413r__oger
rollover1144453rollover
roofer94415283r_oofer
roomer84718633r_oomer
rooser63921883r_ooser
rooter64926033r_ooter
roper75431913r__oper
rounder83514603roun_der
rove75136983r__ove_
roved95323553r__oved
roven85521973r__oven
rovers95423523r__overs
roves84834483r__oves
rower85430493r__ower
rubber104715793ru_bber
rubier84814743ru_bier
rudder83812803ru_dder
ruddier9338523ruddier
ruder65320543ru__der
ruer46127563ru___er
ruffler13369723ruffler
rugger84414513ru_gger
rugose737283rugose_
ruiner64013643ru_iner
ruler54923343ru__ler
rulier65016353ru_lier
rumbler113514113rumbler
rummer104715483ru_mmer
rummier11309563rummier
rumor71011323rumo__r
rumored1046643rumored
rumour8127383rumo_ur
rundle73214233rundle_
rundles83214713rundles
rundlet83114153rundlet
rune45236303run__e_
runes55530223run__es
runkle103611543runkle_
runkled12399013runkled
runkles114111943runkles
runlet63821413run_let
runnel63510673run_nel
runners74212453run_ners
runoff1235413runo_ff
runoffs1343013runoffs
runout6414873runo_ut
runouts737353runouts
rusher94019653ru_sher
rushier103411973rushier
rustier74416363rustier
rustler73512343rustler
ruttier73412283ruttier
shover124515993_shover
snorer64316763_snorer
stover94115643_stover
suaver93014233su_aver
sunder74019823sun_der
sunnier73412153sunnier
tenoner739683tenoner
trover95014663_trover
trundler9256153trundler
tuner56022683tun__er
turnovers1243283turnovers
tutoyer1033793tutoyer
uncovers1336573_uncovers
under64624213_un_der
undoer73113043_undoer
uneven957913_uneven
uniter64619143_uniter
unloved112310533_unloved
unmoved13248903_unmoved
unopen838913_unopen
unrove92511683_unrove_
unroven10238143_unroven
unsober967643_unsober
unwove12238883_unwove_
unwoven13176673_unwoven
venomer1237583venomer
wingover1544303wingover

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.423422437.4
2DLD Change Limit1340272107.15618729.3
3Display Results2102100.0762763.2
 (SQL Overall)1786912107.65523343.0
 
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.