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

124 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
ligulate9251024(None) 
ligulae8308751ligula_e
ligulated11247351ligulated
lingulate10368181lingulate
angulate9312012angulate
cingulate12238582cingulate
figurate1237182figurate
jugulate1645482jugulate
ligate72519242lig__ate
ligula7359672ligula__
ligular8348532ligula_r
ligulas8329162ligula_s
ligule74010832ligul__e
lingulae9357022lingula_e
liquate1638412liqu_ate
lobulate1078832lobulate
loculate101011402loculate
lunulate838252lunulate
regulate9313022regulate
simulate10311132simulate
ungulate939802ungulate
virgulate1345232virgulate
aciculate132510803aciculate
acidulate12256893acidulate
adulate8313233_adulate
ambulate1239733ambulate
angulated1139213angulated
angulates10310853angulates
annulate8310923annulate
apiculate13279883apiculate
bijugate1843513bijugate
bisulcate13144063bisulcate
bisulfate14143653bisulfate
canulate10314553canulate
circulate13810433circulate
coagulate1258073coagulate
copulate122614113copulate
cumulate123110223cumulate
cupulate122810033cupulate
digitate1098683digitate
dilate73220693di__late
disulfate13145713disulfate
divulgate1463103divulgate
emulate9314123_emulate
fabulate1339203fabulate
fibulae12237013fibula_e
figuline1256033figuline
fistulate1246453fistulate
gelate73421253__gelate
hamulate1359013hamulate
inflate10312313_inflate
insulate8312843insulate
inulase739413_inulase
isolate7313923_isolate
jaculate172311783jaculate
jugulated1844023jugulated
jugulates1744593jugulates
lacunate10128963lacunate
lazulite1745033lazulite
legate72917453leg__ate
legislate1084673legislate
liberate101113383liberate
librate93214233li_brate
liftgate1243413liftgate
ligase7259913lig__ase
ligated92414133lig__ated
ligates82318373lig__ates
lignite81310303lig_nite
ligules82210913ligul_es
liguloid1044123liguloid
ligure7279473ligu__re
limbate1139213li_mbate
lineate7815153li_neate
lineolate946283lineolate
linguae8398403lingu_a_e
lingula8428793lingula__
lingular9407493lingula_r
linoleate944723linoleate
liquated1835483liqu_ated
liquates1737443liqu_ates
liquidate1943763liquidate
literate81216883literate
litigate948303litigate
lobulated12106423lobulated
loculated1288313loculated
lunate6316043l__unate
lunulae735613lunula_e
lunulated1036783lunulated
luxate1338083l__uxate
maculate122815623maculate
migrate101314163mig_rate
modulate1138593modulate
osculate101010613osculate
ovulate1039453_ovulate
peculate122414663peculate
pinnulate1145763pinnulate
planulate1146903planulate
populate122812093populate
regelate9312083regelate
regulated11310463regulated
regulates101211703regulates
rosulate8310903rosulate
sibilate1049533sibilate
sigmate10710123sig_mate
simulated1238283simulated
simulates1139843simulates
sinuate7412153sinu_ate
situate7410773situ_ate
spiculate132210163spiculate
stimulate1148233stimulate
stipulate1147323stipulate
subulate10312743subulate
tabulate10310893tabulate
tegulated1146633tegulated
tinplate1047733tinplate
tribulate1148083tribulate
tubulate1038273tubulate
ululate749963_ululate
undulate9310403undulate
ungulae837313ungula_e
ungulates1048343ungulates
ustulate868323ustulate
vigilante1343633vigilante
violate10311553vi_olate

Search took 7 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 Limit1461621246.62322068.9
3Display Results1241240.0631968.3
 (SQL Overall)1786911246.84226116.8
 
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.