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

115 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
ungulate93980(None) 
angulate9312011angulate
undulate9310401undulate
ungulae837311ungula_e
ungulates1048341ungulates
angulated1139212angulated
angulates10310852angulates
annulate8310922annulate
cingulate12238582cingulate
insulate8312842insulate
jugulate1645482jugulate
ligulate92510242ligulate
lingulate10368182lingulate
lunulate838252lun_ulate
regulate9313022regulate
ululate749962u_lulate
undulated11310082undulated
undulates1048922undulates
ungula737602ungula__
ungular836772ungula_r
ustulate868322ustulate
adulate8313233_adulate
ambulate1239733ambulate
angular838533angula_r
angulose945163angulose
annulated1038603annulated
cannulate1148633cannulate
canulate10314553canulate
coagulate1258073coagulate
consulate11612233consulate
copulate122614113copulate
cumulate123110223cumulate
cupulate122810033cupulate
emulate9314123_emulate
endplate1147083endplate
fabulate1339203fabulate
figurate1237183figurate
fulgurate1344063fulgurate
gelate73421253__gelate
hamulate1359013hamulate
incubate1238663incubate
incudate1138873incudate
inculcate1347433inculcate
inculpate1346793inculpate
indurate9311873indurate
inflate10312313in_flate
ingate73018233ing__ate
ingrate8715113ing_rate
inoculate1149623inoculate
insolate8311893insolate
insulated10310713insulated
insulates9311843insulates
intubate1047533intubate
inulase739413in_ulase
jaculate172311783jaculate
jugulated1844023jugulated
jugulates1744593jugulates
ligulae8308753ligula_e
ligulated11247353ligulated
lingulae9357013lingula_e
lobulate1078833lobulate
loculate101011403loculate
lunulae735613lun_ula_e
lunulated1036783lun_ulated
maculate122815623maculate
modulate1138593modulate
nutate63017373_n_utate
osculate101010613osculate
ovulate1039453_ovulate
peculate122414663peculate
pinnulate1145763pinnulate
populate122812093populate
pullulate1144703pullulate
pustulate1177243pustulate
regelate9312083regelate
regulated11310463regulated
regulates101211703regulates
rosulate8310903rosulate
simulate10311133simulate
subulate10312743subulate
tabulate10310893tabulate
tegulated1146633tegulated
tubulate1038273tubulate
tungstate1042863tungstate
ululated947663u_lulated
ululates848433u_lulates
uncinate10312393uncinate
uncrate9415953un_crate
uncreate10311353uncreate
uncute82912133uncu__te
underate9918603underate
undulance1244063undulance
undulant946823undulant
undular837123undula_r
undulator1045393undulator
ungated92717213ung__ated
unglazed1936263ung_lazed
unglove1136103ung_love
unglue748003ung_l_ue
ungual738183ungu_a_l
unguard955093ungu_ard
unguent839123unguent_
unguenta943713unguenta
unguents945153unguents
unijugate1742473unijugate
unlace82215173un__lace
unlade72714153un__lade
unornate848013unornate
unpolite1049173unpolite
unquote1645903unqu_ote
unregulated1344403unregulated
unrelated10310433unrelated
unstate71916213un_state
uvulae945323u_vula_e
virgulate1345233virgulate

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.376475242.0
2DLD Change Limit1461621158.93616356.5
3Display Results1151150.0462500.0
 (SQL Overall)1786911159.35819095.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.