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

219 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
prutah113658(None) 
pruta7314241pruta_
brutal859382brutal
crutch13408242crutch
grutch12285562grutch
pretax152310192pretax
prutot8311822prutot
prutoth1243472prutoth
pujah17478542p_ujah
purdah12288752purdah
ruth76825992_rut_h
truth85214152trut_h
artal55525473ar_tal
breath113916263breath
brith104924373brit_h
broth106521093brot_h
brugh115414293bru_gh
brumal1049503brumal
brunch13329353brunch
brush105917473bru_sh
brut66537963brut__
brute75321783brut_e
bruted95113263bruted
brutes86118683brutes
brutish1237703brutish
bruts75922953brut_s
butch125416543_butch
chetah14399583chetah
clutch13367753clutch
couth106122483cout_h
cratch134110793cratch
crotch133410083crotch
crunch13349503crunch
crura7312583crura_
crural8610633crural
crush106815993cru_sh
crustal939023crustal
crwth1337483crwt_h
curtal83914543curtal
cutch125116193_cutch
dourah10479813dourah
drouth104410103drout_h
dutch114713823_dutch
frith115922033frit_h
froth115919283frot_h
frugal1036393frugal
frusta937453frusta_
grith95520373grit_h
houdah1335173houdah
hurrah12369183hurrah
hutch135414093_hutch
kurta95113913kurta_
kurtas10349883kurtas
lotah85315853_lotah
mouth105420293mout_h
mutch125016173_mutch
nautch1144813nautch
pah88853593p___ah
pardah123412823pardah
pariah114320583pariah
partan83820563partan
parura8310583parura_
paruras9310533paruras
pasta76624533pasta_
pastas85422873pastas
patch125221223p_atch
path99134913p_at_h
paunch13369853paunch
pausal81511963pausal
pentad9313763pentad
perusal939193perusal
petal76526893p_etal
phut96925973phut__
phuts104613503phut_s
pieta75421753pieta_
pietas84516503pietas
pinta75727053pinta_
pintas85021393pintas
pita65436433p_ita_
pitas77427673p_itas
pitch125018413p_itch
pith95432693p_it_h
pitta75018693pitta_
pittas86014523pittas
platan83913693platan
plural839823plural
plush105614713plu_sh
plutei8408903plutei
pluton838853pluton
pooftah1543143pooftah
portal84218463portal
postal84317533postal
potash1138273p_otash
pouch124617083pou_ch
pout65752553pout__
pouted94021393pouted
pouter83923983pouter
pouts75530323pout_s
pouty107018813pout_y
praam94815613pr_aam
prahu105013973pr__ahu
pram85733493pr__am
prao66229023pr__ao
prat65952043pr__at
prate75135983prat_e
prated94924923prated
prater84825353prater
prates84633163prates
prats76333393prat_s
prau66529473pr__au
pray96331533pr__ay
preach133613923preach
prefab1336243prefab
prelaw1139103prelaw
preman104117453preman
prepay13310313prepay
presa74319043presa_
pretape113511623pretape
pretor8315743pretor
pretty11510873pretty
prewar114712573prewar
prewash1535213prewash
prima95019343prima_
primal104014623primal
primas104418103primas
proa66229963pr_oa_
proas75028803pr_oas
prolan8414693prolan
protea82214763protea
protean92412193protean
proteas92015123proteas
protei82615303protei
proton84318893proton
protyl11308213protyl
prowar114110943prowar
prude84615973pru_de
prudes94215443prudes
prudish1376563prudish
prune75119633pru_ne
pruned93413113pruned
pruner83413453pruner
prunes83419063prunes
prunus8399363prunus
pugh106619233p_u_gh
puja135714923p_uja_
pujahs18404943p_ujahs
pujas145513323p_ujas
pula65129373p_ula_
puma85424123p_uma_
pumas95121563p_umas
puna65331653p_una_
punas74826753p_unas
punch125118423p_unch
punkah15347093punkah
pupa85422813p_upa_
pupae96515643p_upae
pupal97616873p_upal
pupas95219283p_upas
purda82914693purda_
purdahs13285483purdahs
purdas92612263purdas
puritan939283puritan
purty105019403purt_y
push95526623p_u_sh
put55759073p_ut__
puton73617913p_uton
puts65641753p_ut_s
putsch1334933p_utsch
putt66937843p_ut_t
putti76018743p_utti
putto75617663p_utto
putts75719273p_utts
putty104721403p_utty
putz158326323p_ut_z
rah68052403_r__ah
rajah155711423_rajah
ratal55025113_ratal
ratan53722663_ratan
ratch104221363_ratch
rath76037663_rat_h
rayah116013503_rayah
retag63618413_retag
retax124517973_retax
retch104818303_retch
rota45834343_rota_
rotas54827723_rotas
rotch105815933_rotch
routh86423073rout_h
ruga56121233_ruga_
rugae65114763_rugae
rugal65916093_rugal
rupiah1146213_rupiah
rural55821173_rural
rush76628183_ru_sh
rut35560523_rut__
ruths85714643_ruths
rutin55421343_rutin
ruts44541493_rut_s
rutty85617803_rutty
scuta75815753scuta_
scutch13247083scutch
smutch13205843smutch
south85223573sout_h
sputa74612963sputa_
subah106015213_subah
surah86823253_surah
surtax1337843surtax
trefah1235093trefah
troth85622203trot_h
truths9449503truths
uprush1135783upru_sh
uta37425583__uta_
utas45924953__utas
wrath115715873wrat_h
wreath124111193wreath
wretch14326533wretch
wroth116815883wrot_h
youth115315043yout_h
yurta86014253yurta_

Search took 5 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.1401276364.3
2DLD Change Limit1127162194.65624208.8
3Display Results2192190.0633476.2
 (SQL Overall)1786912194.85936775.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.