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

237 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
prutot831182(None) 
prutoth1243471prutoth
brulot8912212brulot
pluton838852pluton
pretor8315752pretor
proton84318892proton
pruta7314242prut_a
prutah1136582prutah
puton73617912p_uton
putout8315112p_utout
putt66937842p_ut_t
putto75617662p_utto
apricot111010183apricot
argot67728653ar_got
auto47432083_auto_
autos56523323_autos
bouton8311533bouton
britt75732233brit_t
bruit76126723bru_it
brulots946223brulots
brunet84419293brunet
brunt75728753bru_nt
brut66537963bru__t
brutal859383brutal
brute75321783brut_e
bruted95113263bruted
brutes86118683brutes
bruts75922953brut_s
burbot10815653burbot
burton8311273burton
butt65143743_but_t
butut75522913_butut
craton84517193craton
croton84415453croton
crouton947133crouton
cruet74831843cru_et
cruor7310453cru_or
cruset84425093cruset
crust75827663cru_st
crutch13408243crutch
cutout8315923_cutout
drylot1037403drylot
ergot65422893er_got
eruct74022353eru_ct
erugo6369853erugo_
erugos7347343erugos
erupt74220063eru_pt
fritt86129413frit_t
fruit85122223fru_it
futon83113773_futon
griot65328413gr_iot
grot55942053gr__ot
grotto7349813grotto
grunt65523543gru_nt
grutch12285563grutch
guyot9314523_guyot
krubut1245553krubut
mouton8410853mouton
muton73817003_muton
mutt65739403_mut_t
orator6314533orator
paletot9413713paletot
panto76129413panto_
pantos85222743pantos
parrot8320663parrot
parton84720993parton
pastor84817483pastor
peridot10514243peridot
pesto75723723pesto_
pestos84719083pestos
petit74332653p_etit
petto76021043petto_
phot95534363p__hot
photo104417233photo_
photog12379813photog
photon1111514833photon
photos113316643photos
phut96925973phu__t
phuts104613503phut_s
phytol14366563phytol
phyton143610253phyton
picot95031013p_icot
pilot77435063p_ilot
pinot78737293p_inot
pinto75625753pinto_
pintos86021293pintos
pistol83313333pistol
piston83515923piston
pistou83211843pistou
piton76121583p_iton
pivot106523873p_ivot
plot66141233p__lot
plutei8408903plutei
plutons938343plutons
ponton83217643ponton
postop10511943postop
pot58078433p___ot
potto75320943potto_
pottos84615873pottos
poult76928873pou_lt
pout65752553pou__t
pouted94021393pouted
pouter83923983pouter
pouts75530323pout_s
pouty107018813pout_y
praetor938973praetor
prao66229023pr_ao_
praos74923563pr_aos
prat65952043pr__at
prate75135983prat_e
prated94924923prated
prater84825353prater
prates84633163prates
prats76333393prat_s
preact103220393preact
precut102016533precut
premolt11312073premolt
preop94715873pr_eop
preriot9316413preriot
preset84430983preset
presort95219543presort
prest75736353pr_est
presto84216203presto_
prestos93716083prestos
pretax152310193pretax
pretest9517633pretest
pretext1639663pretext
pretold1049083pretold
pretors9316813pretors
pretty11510873pretty
priest84125423priest
primo95017913primo_
primos104514423primos
print74837463pr_int
printout1048123printout
prion75119993pr_ion
prior74316173pr_ior
prison8514023prison
privet113821343privet
pro55837263pr__o_
proa66229963pr__oa
probit103218353probit
proctor11310433proctor
prod76129503pr__od
prof96134663pr__of
profit113016273profit
prog75729003pr__og
projet15315183projet
prolog94212973prolog
prom87631703pr__om
promo95620003promo_
promos105116423promos
promote11313143promote
prompt12313013prompt
pronota939763pronota
pronto8313993pronto_
proof105221533pr_oof
prop85932813pr__op
pros65742783pr__os
prosit85124593prosit
proso77222413proso_
prosos85718553prosos
prost75434103pr_ost
protea82214763protea
protect11313633protect
protei82615313protei
protest9317533protest
protist9320223protist
protons93118003protons
protyl11308213protyl
provost1238573provost
prow97030383pr__ow
prude84615973pru_de
prudent10310433prudent
prudes94215443prudes
prune75119633pru_ne
pruned93413113pruned
pruner83413453pruner
prunes83419063prunes
prunus8399363prunus
punt65747203p_u_nt
punto75121323punto_
puntos85915793puntos
purest84021933purest
purist85525053purist
purport1159393purport
purty105019403purt_y
put55759073p_u__t
putlog965553p_utlog
putoff1436423p_utoff
putons83515153p_utons
putouts937083p_utouts
puts65641753p_ut_s
putti76018743p_utti
putts75719273p_utts
putty104721403p_utty
putz158326323p_ut_z
rato45436973_rato_
ratos55528763_ratos
repot75132623_repot
retort66831153_retort
riot45947213_r_iot
robot7325973_robot
root45655923_r_oot
rot37282953_r__ot
roto45935053_roto_
rotor55519733_rotor
rotos56027883_rotos
rubout8313563_rubout
rumor71011323_rumor
runout6414873_runout
runt46647993_ru_nt
rust45544913_ru_st
rut35560523_ru__t
ruth76825993_rut_h
ruths85714643_ruths
rutin55421343_rutin
ruts44541493_rut_s
rutty85617803_rutty
ryot75528563_r_yot
shutout1048533shutout
stot46347333__stot
surtout7411673surtout
tautog765713tautog
tot38884773___tot
tricot8317753tricot
triton63914893triton
trot46351313tr__ot
truant6315783truant
truest64816193truest
trust55426853tru_st
trustor7238413trustor
truth85214153trut_h
truths9449503truths
turbot8914263turbot
tutor5712493_tutor
uproot8314123upr_oot

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162375.08022188.2
3Display Results2372370.0603950.0
 (SQL Overall)1786912375.51332412.7
 
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.