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

127 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
undulate931040(None) 
undulated11310081undulated
undulates1048921undulates
ungulate939801ungulate
adulate8313232_adulate
angulate9312012angulate
annulate8310922annulate
endplate1147082endplate
indurate9311872indurate
insulate8312842insulate
lunulate838252lun_ulate
modulate1138592modulate
ululate749962u_lulate
underate9918602underate
undulance1244062undulance
undulant946822undulant
undular837122undula_r
undulator1045392undulator
ungulae837312ungula_e
ungulates1048352ungulates
ustulate868322ustulate
acidulate12256893acidulate
adulated1039753_adulated
adulates9311913_adulates
ambulate1239733ambulate
angulated1139223angulated
angulates10310863angulates
annulated1038603annulated
bedplate1346223bedplate
cannulate1148633cannulate
canulate10314553canulate
cingulate12238603cingulate
consulate11612233consulate
copulate122614113copulate
cumulate123110223cumulate
cupulate122810033cupulate
delate73827753__delate
dilate73220693__dilate
educate10310213_educate
emulate9314123_emulate
endplates1246843endplates
fabulate1339203fabulate
hamulate1359013hamulate
incubate1238663incubate
incudate1138873incudate
inculcate1347433inculcate
inculpate1346793inculpate
indagate1047193indagate
indicate11313353indicate
indulge945403indul_ge
induline939493induline
indult73614033indul_t_
indults8289493indul_ts
indurated1139013indurated
indurates10310693indurates
indusiate1046403indusiate
inflate10312313in_flate
inoculate1149623inoculate
insolate8311893insolate
insulated10310713insulated
insulates9311843insulates
intubate1047533intubate
inulase739413in_ulase
jaculate172311783jaculate
jugulate1645483jugulate
ligulate92510253ligulate
lingulate10368193lingulate
lobulate1078833lobulate
loculate101011403loculate
lunulae735613lun_ula_e
lunulated1036783lun_ulated
maculate122815623maculate
manducate1445773manducate
modulated1336713modulated
modulates1238053modulates
nutate63017373_n_utate
obdurate1175123obdurate
osculate101010613osculate
ovulate1039453_ovulate
pandurate1245883pandurate
peculate122414673peculate
pinnulate1145763pinnulate
populate122812093populate
pullulate1144703pullulate
pustulate1177243pustulate
radulae837963radula_e
regulate9313023regulate
rosulate8310903rosulate
simulate10311133simulate
subulate10312743subulate
tabulate10310893tabulate
tubulate1038273tubulate
ululated947663u_lulated
ululates848433u_lulates
unadult856643unadul_t_
uncinate10312393uncinate
uncrate9415953un_crate
uncreate10311353uncreate
uncute82912133uncu__te
undated93118463und__ated
undebated1338093undebated
undeleted1148063undeleted
underage101012273underage
underrate10411893underrate
undiluted1144903undiluted
undrape1049333und_rape
undue66715553undu___e
undulances1343373undulances
undulating1247143undulating
undulation1147103undulation
undulators1144833undulators
undulatory1444083undulatory
undulled1036993undulled
unduly1037823undul__y
uneducated1444523uneducated
ungula737603ungula__
ungular836773ungula_r
unijugate1742473unijugate
unlace82215173un__lace
unlade72714153un__lade
unornate848013unornate
unpolite1049173unpolite
unquote1645903unqu_ote
unrelated10310433unrelated
unstate71916213un_state
update93810293upd__ate
uvulae945323u_vula_e

Search took 8 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.420425454.8
2DLD Change Limit1461621276.78321548.3
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.24924650.4
 
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.