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

122 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
ligulae830875(None) 
ligula7359671ligula_
ligular8348531ligular
ligulas8329171ligulas
ligulate92510251ligulate
ligule74010831ligul_e
lingulae9357031lingulae
fibulae12237012fibulae
ligulated11247362ligulated
ligules82210922ligules
ligure7279472ligu_re
linguae8398412lingu_ae
lingula8428802lingula_
lingular9407502lingular
lingulate10368192lingulate
lunulae735612lunulae
ungulae837312ungulae
aciculae12267703aciculae
aiguille943303aiguille
alulae6312743_alulae
angular838533angular
angulate9312013angulate
canulae9311183canulae
cingula10327173cingula_
cingular11256973cingular
cingulate12238603cingulate
copulae112810613copulae
cupulae11347853cupulae
divulge1243103divulge
divulse1134913divulse
faculae123210353faculae
feculae12339203feculae
ferulae10309603ferulae
fibula11258053fibula_
fibular12267973fibular
fibulas12228563fibulas
figuline1256033figuline
figural1145243figural
figurate1237193figurate
figure10258833figu_re
fistulae1144533fistulae
giggle94313513giggl_e
gigue71210673gigu__e
gulag7310823__gulag
gular6314833__gular
higgle113811743higgl_e
inulase739413_inulase
jiggle153811993jiggl_e
jugula1434983jugula_
jugular1534513jugular
jugulate1645483jugulate
lacunae9116803lacunae
laguna7127223laguna_
lagunas8156823lagunas
lagune7158633lagu_ne
laurae64011663l_aurae
legume936913legu_me
liable81415813liabl_e
libelee92510983libelee
liblab1035083li_blab
librae84310173li_brae
ligan67920283lig__an
ligase7259913lig_ase
ligate72519253lig_ate
lignan75510323lig_nan
lignite81310303lignite
liguloid1044133liguloid
ligures8269893ligures
likuta1034213likuta_
lilac7311073li__lac
limuli836343limul_i
limulus935083limulus
lingua7509913lingu_a_
lingual8379083lingu_al
linguals9317223linguals
linguine937593linguine
liquate1638423liquate
lisle53916723li_sl_e
little63312163littl_e
lobular936663lobular
lobulate1078833lobulate
lobule82910063lobul_e
locular938953locular
loculate101011403loculate
locule83412033locul_e
lunula636173lunula_
lunular736013lunular
lunulate838253lunulate
lunule638433lunul_e
maculae113412863maculae
miggle104012113miggl_e
morulae958963morulae
nebulae955493nebulae
niggle83612823niggl_e
papulae11249353papulae
pilular938203pilular
pilule8411123pilul_e
pinnulae1044183pinnulae
planulae1044793planulae
radulae837963radulae
regular838423regular
regulate9313023regulate
sigla64515203sig_la_
siliculae1154283siliculae
simular938673simular
simulate10311133simulate
singular9327563singular
spiculae12218603spiculae
spinulae10276963spinulae
spirulae10216573spirulae
tegular836603tegular
titular737523titular
torulae758553torulae
ungula737603ungula_
ungular836773ungular
ungulate939803ungulate
uvulae945323_uvulae
villae95615383vi_llae
virgulate1345233virgulate
virgule1144283virgul_e
wiggle113713013wiggl_e
zonulae1645963zonulae

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271227.31318327.2
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.74923059.9
 
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.