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

135 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
rosulate831090(None) 
consulate11612232consulate
copulate122614112copulate
insulate8312842insulate
lobulate1078832lobulate
loculate101011402loculate
modulate1138592modulate
osculate101010612_osculate
ovulate1039452_ovulate
populate122812092populate
postulate1169812postulate
regulate9313022regulate
reslate73520592res_late
roseate7613452ros_eate
rostrate8313842rostrate
roulade857002ro_ulade
adulate8313233_adulate
ambulate1239733ambulate
angulate9312013angulate
annulate8310923annulate
bisulcate13144063bisulcate
bisulfate14143653bisulfate
canulate10314553canulate
capsulate1347563capsulate
coagulate1258083coagulate
collate92919683co_llate
conflate13311173conflate
consulates12711103consulates
copulae112810613copula_e
copulated142710483copulated
copulates132612463copulates
corelate10516013corelate
costate94019273cos_tate
crenulate1167693crenulate
cumulate123110223cumulate
cupulate122810033cupulate
desolate9411993desolate
disulfate13145713disulfate
emulate9314123_emulate
fabulate1339203fabulate
fistulate1246453fistulate
folate93320393fo__late
formulate1446993formulate
fossate10388603fos_sate
granulate1059183granulate
gratulate1047683gratulate
hamulate1359013hamulate
inoculate1149623inoculate
inosculate1245913inosculate
insolate8311893insolate
insulated10310713insulated
insulates9311843insulates
isolate7313923_isolate
jaculate172311783jaculate
jugulate1645483jugulate
ligulate92510253ligulate
lobulated12106423lobulated
loculated1288313loculated
lunulate838253lunulate
maculate122815623maculate
modulated1336713modulated
modulates1238053modulates
morulae958963morula_e
moschate1546583moschate
moulage1037903mo_ulage
oblate82214743_o_blate
osculated1298143_osculated
osculates11109393_osculates
outate62923403_o_utate
ovulated1237083_ovulated
ovulates1148523_ovulates
oxalate1457623_oxalate
peculate122414663peculate
populace14256253populace
populated14228803populated
populates132710673populates
postdate1139653postdate
postulated1377653postulated
postulates1268963postulates
prolate9419793pro__late
promulgate1553013promulgate
proselyte1444843proselyte
prostate10314533pros_tate
prostrate11412483prostrate
pustulate1177243pustulate
radulae837963radula_e
reflate103516263r_eflate
regelate9312083regelate
regulated11310463regulated
regulates101211723regulates
relate64033633r__elate
replate93420053r_eplate
repopulate1445203repopulate
resalute857413resalute
resinate8316773resinate
reslated93517523res_lated
reslates83619503res_lates
resolute868513resolute
resonate8513513resonate
restate73824883res_tate
result6318223resul_t_
resulted939713resul_ted
results739833resul_ts
roommate1244863roommate
roquette1755533roquette
roselike12169183roselike
roselle7310243rosel_le
rosette7310373ros_ette
rosewater1245023rosewater
rotate63320343ro__tate
roulades957173ro_ulades
roulette847093ro_ulette
route55132073ro_u__te
rugate75813813r__ugate
scopulate1366543scopulate
simulate10311133simulate
slate55438283__s_late
solate64526073__solate
soulmate1047183so_ulmate
sporulate1146953sporulate
sublate9315363__sublate
subulate10312743subulate
sulcate9314423__sulcate
sulfate10311653__sulfate
tabulate10310893tabulate
toeplate1047613toeplate
toluate7159343tolu_ate
torulae758553torula_e
tribulate1148083tribulate
tubulate1038273tubulate
ululate749963_ululate
undulate9310403undulate
ungulate939803ungulate
ustulate868323ustulate
zonulae1645963zonula_e

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.1561145455.1
2DLD Change Limit1461621357.95318378.2
3Display Results1351350.0632142.9
 (SQL Overall)1786911358.17221866.3
 
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.