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

253 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
urinated931161(None) 
ruinated939521ruinated
urinate7315361urinate_
urinates8314131urinates
carinated123414272carinated
crenated113013912crenated
marinated122513172marinated
muriated1139792muri_ated
muricated1448242muricated
printed104016372prin_ted
pronated11414052pronated
ruinate7312832ruinate_
ruinates8311882ruinates
ruminated1258662ruminated
supinated1237882supinated
turbinated1344412turbinated
urinator847842urinator
urticated1247702urticated
acuminated1545873acuminated
agitated1038413agitated
alienated1047743alienated
animated111612373animated
arcuated1138803arcuated
arointed939003aroin_ted
aurated83817793aur__ated
aviated11310263avi_ated
binate8419773_binate_
brigaded1344573brigaded
brinded115112053brin_ded
brindled12407853brindled
brined95118413brin__ed
bromated1339173bromated
brominated1546403brominated
carinate103320253carinate_
coronated123313323coronated
crated94827773cr__ated
created104323453cr_eated
cremated133412963cremated
crenate93317113crenate_
criminated1546823criminated
cringed113312403crin_ged
crinite9513633crinite_
crinites10612763crinites
crinkled15357153crinkled
crispated1445023crispated
cristated1247423cristated
culminated1546103culminated
curated104717583cur__ated
dilated93115823_dilated
dinted84419843_din_ted
dominated1339883dominated
donated93513863_donated
drifted12367953dri_fted
echinated1546483echinated
emanated1139163emanated
epilated11310753epilated
fainted114211723fain_ted
feinted11379623fein_ted
fixated1835533_fixated
flinted114411893flin_ted
fluorinated1563883fluorinated
frigate11311063frigate_
frigates12310933frigates
frighted1657173frighted
fringed123611523frin_ged
fritted113611333fri_tted
fronted114011273fron_ted
fulminated1645023fulminated
fumigated1644723fumigated
furcated1437593fur_cated
furnaced1443513fur_naced
geminated1338553geminated
germinated1446563germinated
glinted9399373glin_ted
gradated1157433gradated
granted94715103gran_ted
grated84523923gr__ated
grifted12379583gri_fted
grimaced1463313grimaced
grinded104210633grin_ded
grinned9378553grin_ned
gritted94110903gri_tted
grunted9339283grun_ted
herniated1346013herniated
hinted104318323_hin_ted
imitated1138263imitated
iodinated1146943iodinated
irrigated1176313irrigated
irritated1076133irritated
jointed15378503join_ted
jubilated1944933jubilated
laminated122610283laminated
lanated8313203_lanated
lariated91212063lari_ated
ligated92414143_ligated
lineated9711063_lineated
linted74021823_lin_ted
loricated1247903loricated
lubricated1545033lubricated
lunated8310823_lunated
marginated14187343marginated
marinaded13276533marinaded
marinate103017783marinate_
marinates112516383marinates
minted94220583_min_ted
minuted10329503_minuted
muriate9313363muri_ate_
muriates10312083muri_ates
muricate12311113muricate_
mutilated1239453mutilated
nidated939863_nidated
nominated1239283nominated
opiated1039483opi_ated
orated74221503or__ated
ordinate9310253ordinate_
ordinates1049003ordinates
oribatid1145463oribatid
orientated1144853orientated
oriented937483oriented
originated1244813originated
ornate6315143or_nate_
oxidated1745033oxidated
ozonated1864593ozonated
paginated13309463paginated
painted104214633pain_ted
patinated123911413patinated
pennated11299543pennated
phonated1447893phonated
pinnated11338553pinnated
pirated102515613_pirated
plicated13310643plicated
pointed103813983poin_ted
prated94924923pr__ated
predated12513273predated
priested1138393priested
primate111516283primate_
primates121515933primates
prinked143412163prin_ked
printer93917303prin_ter
private121513263private_
privater13158533privater
privates131812373privates
probated13410863probated
pronate9418873pronate_
pronates10418373pronates
prorated11513713prorated
quinate16511573quinate_
ranted74324703_ran_ted
rated65441383_r__ated
rebated103619703_rebated
redated93120923_redated
related83327573_related
remated103522473_remated
renamed103114523_renamed
rented74426593_ren_ted
resinated10413283resinated
rifted104115313_ri_fted
righted122912143_righted
rinded84418983_rin_ded
ringed84623843_rin_ged
rinsed75016353_rin_sed
rioted73416373_ri_oted
rivaled1138933_rivaled
riveted11258573_riveted
rotated82715293_rotated
rubricated1545043rubricated
ruined74813323ruin__ed
ruminate10511473ruminate_
ruminates11410193ruminates
sainted84114243sain_ted
seriated92717023seri_ated
sinuated938413_sinuated
spicated13309903spicated
spinate93114813spinate_
sprinted113411163sprin_ted
stinted82914193stin_ted
striated93414153stri_ated
supinate10310313supinate_
supinates1139553supinates
suricate10312613suricate_
suricates11311743suricates
surnamed1135113sur_named
tainted83512423tain_ted
terminated1348163terminated
tincted1037273_tincted
tinted74419533_tin_ted
treated83618703tr_eated
triaged92810443tri_aged
trindled10388693trindled
trined74920713trin__ed
trinketed1444253trinketed
tritiated1047523tritiated
truanted935373truanted
truncated1244583truncated
tunicated12257493tunicated
turbinate1146673turbinate_
turbinates1245773turbinates
ultimated1247313ultimated
ululated947663ululated
unabated11310133unabated
unacted10312733u__nacted
unaged83916423u__naged
unawed103914903u__nawed
unaxed144113093u__naxed
unbated103317733u_nbated
uncinate10312393uncinate_
uncoated11314963uncoated
uncrated11416313uncrated
undated93118463u_ndated
ungated92717213u_ngated
unheated121514553unheated
uninflated1474763uninflated
uninvited1344883uninvited
united74421543u__nited
unmated103317023u_nmated
unnamed102410273u_nnamed
unnoted8311363u_nnoted
unprinted1238133unprin_ted
unrated82621553u_nrated
unrelated10310433unrelated
unrented92413923unren_ted
unrinsed938383unrin_sed
unrivaled1345243unrivaled
unsated83419933u_nsated
unseated91317683unseated
unstated91615813unstated
ununited938683ununited
unwanted12249603unwanted
updated11369423u_pdated
uprated103213323u_prated
uprighted1654213uprighted
uranite72515693uranite_
uranites82514643uranites
urate55432163ur__ate_
urates65027763ur__ates
urinal6614123urina__l
urinals7610263urina_ls
urinaries949203urinaries
urinary1037243urina_ry
urinating10310653urinating
urination9312173urination
urinative1247653urinative
urinators947633urinators
urine55026603urin__e_
urines64724123urin__es
urinose738483urinose_
urticate1049863urticate_
urticates1148903urticates
vaginated14328153vaginated
variated121211393vari_ated
wringed123710193wrin_ged
wrinkled16275353wrinkled
zonated173310533_zonated

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 Limit1461622538.00018270.3
3Display Results2532530.1102300.0
 (SQL Overall)1786912538.56320867.8
 
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.