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

103 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
ustulate86832(None) 
pustulate1177241pustulate
fistulate1246452fistulate
osculate101010612osculate
postulate1169812postulate
pustulated1375542pustulated
pustulates1276212pustulates
stylate10179772_stylate
subulate10312742subulate
ululate749962u_lulate
undulate9310402undulate
ungulate939802ungulate
actuate9311443actu_ate
adulate8313233_adulate
ambulate1239733ambulate
angulate9312013angulate
annulate8310923annulate
astute6310763astu__te
auscultate1253103auscultate
busticate1357753busticate
butylate1345213butylate
canulate10314553canulate
copulate122614113copulate
cumulate123110223cumulate
cupulate122810033cupulate
emulate9314123_emulate
escalate1039323escalate
estate64719763est__ate
estimate10912003estimate
estivate111010003estivate
extubate1745093extubate
fabulate1339203fabulate
fistulae1144533fistula_e
fustigate1345623fustigate
gastrulate1143653gastrulate
gratulate1047683gratulate
hamulate1359013hamulate
insulate8312843insulate
intubate1047533intubate
isolate7313923is_olate
jaculate172311783jaculate
jugulate1645483jugulate
ligulate92510243ligulate
lobulate1078833lobulate
loculate101011403loculate
lunulate838253lunulate
lustrate8310443lust_rate
maculate122815623maculate
maturate10312613maturate
modulate1138593modulate
mutilate10312273mutilate
obturate1077773obturate
osculated1298143osculated
osculates11109393osculates
ostomate1049573ostomate
ovulate1039453_ovulate
peculate122414663peculate
populate122812093populate
postulated1377653postulated
postulates1268963postulates
pullulate1144703pullulate
pustulant1145023pustulant
pustulants1253423pustulants
pustular1045153pustula_r
pustule937683pustul__e
regulate9313023regulate
rosulate8310903rosulate
rusticate1149033rusticate
saturate8312813saturate
scutate9310323_scutate
simulate10311133simulate
situate7410773situ_ate
slate55438283_s__late
solate64526073_s_olate
soulmate1047183_soulmate
spatulate11107173spatulate
state56237333_st__ate
stelae63716483_stela_e
stellate8310503_stellate
stimulate1148233_stimulate
stipulate1147323_stipulate
stomate9313123_stomate
striate74218953_striate
stylite10219613_stylite
sublate9315363_sublate
sufflate1456183sufflate
sulcate9314423_s_ulcate
sulfate10311653_s_ulfate
tabulate10310893tabulate
tubate82813173__tubate
tubulate1038273tubulate
ultimate1049203ultimate
ululated947663u_lulated
ululates848433u_lulates
undulated11310083undulated
undulates1048923undulates
ungulae837313ungula_e
ungulates1048343ungulates
unsaturate1054933unsaturate
unstate71916213unst__ate
upstate91610493upst__ate
urticate1049863urticate
uvulae945323u_vula_e

Search took 10 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 Limit1461621038.86016496.8
3Display Results1031030.0333121.2
 (SQL Overall)1786911039.04919747.0
 
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.