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

231 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
ruinates831188(None) 
ruinate7312831ruinate_
ruinated939521ruinated
ruminates11410191ruminates
urinates8314131urinates
ordinates1049002ordinates
quinate16511572quinate_
quintes164114712quin_tes
resinates9314762resinates
ruminate10511472ruminate_
ruminated1258662ruminated
supinates1139552supinates
urinate7315362urinate_
urinated9311612urinated
acuminates1446883acuminates
agitates9310883agitates
agnates82813193_agnates
alginates10310123alginates
alienates9310683alienates
aluminates1248363aluminates
amirates101114793amirates
animates101316423animates
annates72415423_annates
arginases1046383arginases
arsenates979373arsenates
aviates10313063avi_ates
binate8419773_binate_
brominates1448013brominates
climates12311973climates
cognates11311583cognates
coinages11310803coinages
coinmates1348343coinmates
craniates11310653craniates
criminates1448003criminates
crinites10612763crinites
culminates1447053culminates
curates95323833cu_rates
cyanates13238433cyanates
dilates83220663_dilates
dominates12311743dominates
donates83217223_donates
drainages1145503drainages
dunites8313593du_nites
dunnages10154933dunnages
dunnites947173dunnites
emanates10311333emanates
emirates101214853emirates
enates64026433__enates
epilates10313503epilates
eructates1146953eructates
finales104016013_finales
finites10315923_finites
fixates1737393_fixates
frigates12310933frigates
fruitages1344483fruitages
fulminates1545883fulminates
fumigates1545573fumigates
furcates1339883furcates
furnaces1336053furnaces
geminates12310043geminates
germinates1347763germinates
guanases936233guanases
gunites8313123gu_nites
humates122813193hu_mates
imitates10310503imitates
inanes62519803__inanes
ingates82716913__ingates
inmates92715783__inmates
iodinates1048203iodinates
irrigates1057253irrigates
irritates977223irritates
jubilates1845843jubilates
kainites1238793kainites
khanates1535733khanates
kinases113511123_kinases
laminates112712903laminates
ligates82318383_ligates
linages8813173_linages
lunate6316043lu_nate_
lunated8310823lu_nated
luxates1436973lu_xates
magnates11511613magnates
marginates13168743marginates
marinates112516383marinates
minutes93513443_minutes
muriates10312083muriates
mutates92215793mu_tates
mutilates11310953mutilates
nates55238333___nates
neonates8310063neonates
nidates8311893_nidates
nominates11311053nominates
nutates73214973nu_tates
odonates947743odonates
opiates9312143opi_ates
ordinate9310253ordinate_
originates1145963originates
outdates93114743outdates
outrates82421373outrates
oxidates1636333oxidates
ozonates1745963ozonates
paginates123111363paginates
patinates113814693patinates
penates93321603_penates
phenates13611583phenates
phonates13410643phonates
pinatas93711503_pinatas
pinites9319533_pinites
pirates93020333_pirates
pointes93216753poin_tes
primates121515933primates
privates131812373privates
pronates10418373pronates
pulsates1048813pulsates
pupates113311433pu_pates
quinaries1857873quinaries
quinces183210433quin_ces
quinines172410203quinines
quinnats17124283quinnat_s
quinones17227753quinones
quinsies1737623quinsies
quintals17288003quintals
quintans17337873quintans
quintars17337563quintars
quintas163611713quin_tas
quinte153414523quin_te_
quintet163914453quin_tet
quintets17347203quin_tets
quints154316563quin_t_s
quixotes2443553quixotes
rabbinates1444513rabbinates
radiates92415293radiates
radicates12412073radicates
raffinates1644363raffinates
rainwater1244573rainwater
rainwaters1343723rainwaters
rates55352013r___ates
rebates95123183r_ebates
recrates102420373recrates
redates83423873r_edates
reflates113115663reflates
regrates92618403regrates
reignites1046933reignites
reimages1138373reimages
reincites1148493reincites
reinflates13137213reinflates
reinstates1048293reinstates
reinter73116843rein_ter
reinters82614773rein_ters
reinvades1344643reinvades
reinvites1287033reinvites
relates73731433r_elates
remates93827113r_emates
renames92418053r_enames
rennases848983rennases
rentes65431193r_en_tes
replates102919273replates
resinate8316773resinate_
resinated10413283resinated
reslates83619503reslates
resonates9412403resonates
restates83423433restates
retinites9313503retinites
reunites8312473reunites
rhinitis1145263rhinitis
riatas63915093r_i_atas
rinses64720383r_in_ses
rites54442553r_i__tes
rivages1138873r_ivages
rotates72819773r_otates
ruanas6311263ruana__s
rubaces1139313ru_baces
rubatos9278653ru_batos
rubricates1445893rubricates
rugate75813813ru_gate_
ruinable1039263ruinable
ruinating1039593ruinating
ruination9311273ruination
ruinations1039603ruinations
ruined74813323ruin__ed
ruiner64013643ruin__er
ruiners74213023ruin_ers
ruinous739763ruin_ous
ruins55822033ruin___s
ruminants1144913ruminants
ruminator1166813ruminator
ruminators1286063ruminators
rummages1344933rummages
runagates1044333runagates
runcinate1146473runcinate_
rundles83214713ru_ndles
runes55530223ru_n__es
runkles114111943ru_nkles
runlets73310773ru_nlets
runts55927633ru_n_t_s
rusticates1248053rusticates
senates73322613_senates
sinuates8310963_sinuates
spinages11289293spinages
spinate93114813spinate_
sublates10315003sublates
succinates1445633succinates
suints64617783suin_t_s
suites63727403sui__tes
sulfates11310793sulfates
summates122610493summates
supinate10310313supinate_
supinated1237883supinated
suricates11311743suricates
surnames1037273surnames
tannates81911953tannates
terminates12410003terminates
thionates12106663thionates
truncates1145843truncates
tunicates11268743tunicates
tunnages9195903tunnages
turbinates1245773turbinates
uintaites9136333_uintaites
unites65024853_u_nites
updates10329793_updates
uprates93814863_uprates
uranites82514643uranites
urates65027763_u_rates
urinals7610263urina_ls
urinaries949203urinaries
urinator847843urinator
urinators947633urinators
urines64724123urin__es
urticates1148903urticates
vulgates12237233vulgates
zincates1937743_zincates

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.890200776.4
2DLD Change Limit1461622317.76618820.8
3Display Results2312310.0932483.9
 (SQL Overall)1786912318.74920424.2
 
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.