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 “runts” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

218 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
runts5592763(None) 
aunts55227631aunts
brunts85215451brunts
bunts75729801bunts
cunts76125121cunts
dunts65828411dunts
grunts75511851grunts
hunts86826171hunts
lunts55826901lunts
punts75828001punts
rants55935341rants
rents55935181rents
runes55530221runes
rungs611819401rungs
runs46438071run_s
runt46647981runt_
runty86119041runty
rusts55026991rusts
ruts44541491ru_ts
ants47243472_ants
aunt46553652aunt_
aunty85919812aunty
bents76033692bents
bints76130182bints
blunts84512892blunts
brants85723052brants
brents84717272brents
bruits85714452bruits
brunets9419552brunets
brunt75728752brunt_
bruts75922952bru_ts
bunas75126572bunas
bunds85523542bunds
bundts95010842bundts
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunt65850852bunt_
busts75227692busts
buts67247692bu_ts
butts75824252butts
cants77036942cants
cents74730332cents
counts84618272counts
cruets85314952cruets
crusts84916542crusts
cults75022552cults
cunt66243672cunt_
cuts65841152cu_ts
daunts75014082daunts
dents65031802dents
dints67431312dints
drunks11427512drunks
ducts85319892ducts
duets65323882duets
duits65021882duits
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432dun_s
dunt55746872dunt_
dusts65923562dusts
eructs83610792eructs
erupts8348902erupts
fonts86124752fonts
founts94313382founts
fronts94415792fronts
fruits94512492fruits
funds94119252funds
funks125318912funks
funs75235732fun_s
gents65729612gents
grants73722472grants
grunt65523542grunt_
gunks104517722gunks
guns55533482gun_s
gusts65722792gusts
guts56637252gu_ts
hants86335402hants
haunts95614392haunts
hents87330742hents
hints87330622hints
hunks125321452hunks
huns76136932hun_s
hunt76445492hunt_
hurts86922822hurts
huts76737442hu_ts
jaunts137511882jaunts
junks164815972junks
junta123713672junta
juntas134210502juntas
junto125114562junto
juntos134110842juntos
justs124918262justs
juts115930162ju_ts
lints57137192lints
lunas55025012lunas
lunes55337772lunes
lunets66914762lunets
lungs65223882lungs
lunks94822452lunks
lunt46148842lunt_
lusts55022802lusts
mints76834042mints
mounts84115072mounts
munis75022002munis
muns65535912mun_s
musts75527442musts
muts64839982mu_ts
mutts75120252mutts
nuns45228232nun_s
nuts45032672nu_ts
ousts55225702ousts
outs45746962ou_ts
pants76536922pants
pints75936222pints
prints84320102prints
prunes83419062prunes
prunus8399362prunus
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pun_s
punt65747202punt_
punto75121322punto
puntos85915792puntos
punty106021612punty
puts65641752pu_ts
putts75719272putts
quants153614142quants
quints154316562quints
quits144122352quits
rafts87820632rafts
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rant45864672rant_
rats46260372r_ats
rends65129952rends
rent46661242rent_
rente54733782rente
rentes65431192rentes
rests54935872rests
rets45352562r_ets
rifts85718642rifts
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192rin_s
riots54922012riots
roots55933672roots
rots46454092r_ots
rounds73615612rounds
rousts617016722rousts
routs57133412routs
ruanas6311262ruanas
rubes74928412rubes
rubs66133492ru_bs
rubus76415052rubus
rucks114422052rucks
rudds74811702rudds
ruers515019412ruers
rues46044482ru_es
ruffs114516742ruffs
rugs56033682ru_gs
ruins55822032ruins
rules55234252rules
rumps95922292rumps
rums64833472ru_ms
run36244982run__
rune45236292run_e
rung56429972run_g
runic73615772runic
runlets73310772runlets
runny84613482runny
runouts737342runouts
runtish1048692runtish
ruses56136582ruses
rusks95816192rusks
rust45544912rust_
rusty85221052rusty
rut35560522ru_t_
ruth76825992ru_th
ruths85714642ruths
rutty85617802rutty
rynds9569972rynds
ryots85313782ryots
shunts95712012shunts
strunts7429542strunts
stunts65615252stunts
suets55126102suets
suints64617782suints
suits55028052suits
sunns55017352sunns
suns45841902sun_s
taunts65715662taunts
tents56434212tents
tints56030922tints
truants738152truants
trunks10429752trunks
trusts64714432trusts
tufts85713272tufts
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tuns45138662tun_s
tuts45838452tu_ts
units54923432_units
uns35936752_un_s
unto45824282_unto
urns46323892urn_s
uts35534372_u_ts
vaunts95212622vaunts
vents86125932vents
wants87932212wants
wonts87621542wonts
yurts87216532yurts

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538002182.00026900.0
3Display Results2182180.0603633.3
 (SQL Overall)1786912182.15382996.3
 
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.