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 “obligate” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
obligate1119830(None) 
obligated13186901obligated
obligates12207851obligates
obligati11184831obligati
obligato11194981obligato
ablegate1147252ablegate
colligate1248292colligate
ligate72519242__ligate
obbligati1451812obbligati
obbligato1461872obbligato
oblate82214742obl__ate
obligable1444382obligable
obligately1652942obligately
obligator12195692obligator
obligatos12195062obligatos
oblige937652oblig__e
obligee1046852oblig_ee
obviate1235782obvi_ate
abdicate1348903abdicate
ablate82219213abl__ate
ablegates1246793ablegates
abnegate1144863abnegate
abrogate11129603abrogate
binate8419773_b_inate
blate75933783_bl__ate
blight124114623_blight_
blighted1546863_blighted
blighter1466853_blighter
blights133110213_blights
blighty16356843_blighty
blite76225353_bli__te
brigade1136493_brigade
califate13310483califate
celibate1259313celibate
ciliate9514593cili_ate
climate11312833_climate
colligated1446273colligated
colligates1347713colligates
collimate1348163collimate
delegate10410463delegate
delicate11315493delicate
filiate10414233fili_ate
foliate10513533foli_ate
frigate11311063_frigate
fumigate1446153fumigate
irrigate967633irrigate
kalifate1556493kalifate
legate72917453__legate
levigate1246623levigate
ligase7259913__ligase
ligated92414133__ligated
ligates82318373__ligates
litigate948303litigate
militate10311673militate
mitigate1148693mitigate
navigate1246073navigate
obbligatos1562063obbligatos
obdurate1175123obdurate
objurgate1942183objurgate
oblates91913243obl__ates
obligating1445803obligating
obligation1346783obligation
obligators13195443obligators
obligatory16164173obligatory
obliged1134983oblig_ed
obligees1143943obligees
obliger1035283oblig_er
obligers1134713obligers
obliges1037143oblig_es
obliging1236103obliging
obligor1043533oblig_or
obligors1143523obligors
oblique1844693obli_que
obliterate1245073obliterate
obovate1235463ob_ovate
obstinate1146333obstinate
obturate1077773obturate
obviated1444563obvi_ated
obviates1345153obvi_ates
oleate6318883o_l_eate
oolite63319603ooli__te
opiate8513463o_pi_ate
oppilate1245863oppilate
ordinate9310253ordinate
oubliette1143133oubliette
oxidate1537023o_xidate
plicate11314513_plicate
pollinate1147713pollinate
profligate1654013profligate
relegate9311243relegate
salivate11310013salivate
silicate10312623silicate
sublimate1347423sublimate
tailgate946813tailgate
tollgate946253tollgate
validate1239003validate
vulgate11388433vul_gate

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.280638182.1
2DLD Change Limit146162978.89316435.6
3Display Results97970.0303233.3
 (SQL Overall)178691979.20319416.6
 
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.