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

182 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
ligulas832917(None) 
ligula7359671ligula_
ligulae8308751ligulae
ligular8348531ligular
ligules82210921ligules
fibulas12228562fibulas
lagunas8156822lagunas
ligulate92510252ligulate
ligule74010832ligul_e
ligures8269892ligures
limulus935082limulus
linguals9317222linguals
lingula8428802lingula_
lingulae9357032lingulae
lingular9407502lingular
aciculas12228563aciculas
angular838533angular
argalas84011093argalas
arugulas943913arugulas
begulfs1333753begulfs
canulas9312853canulas
cedulas1058503cedulas
cicalas1139303cicalas
cingula10327173cingula_
cingular11256973cingular
citolas939363citolas
copulas113811563copulas
doulas75114993_doulas
engulfs1143833engulfs
ferulas103110753ferulas
fibula11258053fibula_
fibulae12237013fibulae
fibular12267973fibular
figural1145243figural
figures11239113figures
fistulas1155403fistulas
galas65731643__galas
gigas75415583gig__as
giggles103312933giggles
gigolos934693gigolos
gigues8129003gigu_es
gulag7310823__gulag
gulags837543__gulags
gular6314833__gular
gules64831043__gules
gulfs94915303__gulfs
gulls65222983__gulls
gulps84715073__gulps
guls55930853__gul_s
higgles123911803higgles
hulas84920883__hulas
iglus6609933_ig_lus
iguanas835383_iguanas
ingulfs1134733ingulfs
inulase739413_inulase
jiggles164111433jiggles
jugula1434983jugula_
jugular1534513jugular
jugulars1643233jugulars
kiblas1239323ki_blas
lacunas9138173lacunas
laguna7127223laguna_
lagunes8148523lagunes
lauras63414333l_auras
lazulis1634903lazulis
legals73412733legal_s
legumes1036633legumes
lehuas935943lehu_as
lianas63713383li_anas
libels85112693libel_s
liblab1035083li_blab
liblabs1144123li_blabs
libras83711703li_bras
lieus56218483lieu__s
ligan67920283lig__an
ligands9438983ligands
ligans76817733lig_ans
ligase7259913lig__ase
ligases82310713ligases
ligates82318383ligates
ligers75022043lig_ers
lights104519913lig_hts
lignan75510323lig_nan
lignans8398853lignans
lignins84010493lignins
ligulated11247363ligulated
liguloid1044133liguloid
ligure7279473ligu_re
likuta1034213likuta_
lilac7311073li__lac
lilacs837483li__lacs
lilos55821873li__los
lilts55822803li__lts
limas75627633li__mas
limbas105313203li_mbas
limpas105513083li_mpas
limuli836343limul_i
lingas75116573li_ngas
lingua7509913lingu_a_
linguae8398413lingu_ae
lingual8379083lingu_al
linguicas1243063linguicas
linguisa944473linguisa
linguisas1043573linguisas
lingulate10368193lingulate
linums838283linu_ms
lipomas1156443lipomas
liquids1735823liquids
liquors1634433liquors
liras56021983li__ras
lisles63416283li_sles
litas54923773li__tas
lithias1038823lithias
littles73212783littles
lobular936663lobular
lobules92510813lobules
locular938953locular
locules92812603locules
loculus9296973loculus
loggias9356783loggias
loumas84812333l_oumas
lulls54119653l__ulls
lulus54315163l__ulus
lumas75622913l__umas
lunas55025013l__unas
lunula636173lunula_
lunulae735613lunulae
lunular736013lunular
lunules738953lunules
maculas113114023maculas
miauls8178713miaul_s
miggles113512033miggles
mizunas1843693mizunas
moguls948563mogul_s
morulas959723morulas
nebulas957583nebulas
nigellas944723nigellas
niggles93512203niggles
oligurias10143253oligurias
piculs103511753picul_s
pilular938203pilular
pilules9510623pilules
plugolas1143133plugolas
primulas1246123primulas
radulas839583radulas
ranulas7311773ranulas
regular838423regular
regulars936253regulars
regulus836523regulus
rituals738353rituals
rugolas836373rugolas
sigils73912363sigil_s
sigla64515203sig_la_
siglos7311473sig_los
sigmas94111363sig_mas
signals8359163signals
simular938673simular
simulars1047073simulars
singular9327563singular
singulars10305633singulars
spirulas10207203spirulas
teguas768013tegu_as
tegular836603tegular
titular737523titular
titulars845863titulars
torulas759853torulas
ungula737603ungula_
ungulae837313ungulae
ungular836773ungular
uvulas946523_uvulas
vicunas1285613vicunas
vigas94817883vig__as
vigias104110893vig_ias
vigils104210193vigil_s
villas96117263vi_llas
violas93713523vi_olas
virgules1244333virgules
visuals1036863visuals
vizslas1943143vizslas
weigelas1243103weigelas
wiggles123312463wiggles
zonulas1637023zonulas

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 Limit1340271826.90619407.3
3Display Results1821820.0632888.9
 (SQL Overall)1786911827.35924282.0
 
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.