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

134 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
lingula842880(None) 
cingula10327171cingula
ligula7359671li_gula
lingua7509911lingu_a
lingual8379081lingual
lingulae9357031lingulae
lingular9407501lingular
cingular11256972cingular
ingulf10310352_ingulf
ligulae8308752li_gulae
ligular8348532li_gular
ligulas8329172li_gulas
ligule74010832li_gule
linga66820822ling__a
linguae8398412linguae
linguals9317222linguals
linguica1143482linguica
linguisa944472linguisa
lingulate10368192lingulate
lunula636172lun_ula
pinnula934922pinnula
singular9327562singular
ungula737602_ungula
vincula1246402vincula
angular838533_angular
arugula843913arugula
bilingual1252433bilingual
cannula937433cannula
canula8312963can_ula
cingulate12238603cingulate
cingulum1342723cingulum
coagula1045413coagula
dingily1238103dingily
dingle84317073ding_le
dingus83611843dingu_s
dongola945473dongola
engulf1038883_engulf
fibula11258053fi_bula
fistula1045503fistula
gingal81010153gingal_
gingall9117333gingall
gingals9109313gingals
gingeli9286153gingeli
gingely12378213gingely
gingili9306033gingili
gingiva1253293gingiva
hangul1049223hangul_
incult82414773_incult
indult73614033_indult
ingle64120433_ing_le
ingulfs1134733_ingulfs
inocula947273_inocula
insular7138703_insular
insult62813673_insult
jingal1498593jingal_
jingall1566173jingall
jingals1588073jingals
jingle143815223jing_le
jingly174111933jing_ly
jugula1434983_jugula
kingly143511303king_ly
laguna7127223l_aguna
langue71012183langu_e
langues81211913langues
languet8713693languet
languid936623languid
languor895423languor
langur7109313langu_r
langurs889103langurs
ligulate92510253li_gulate
ligules82210923li_gules
ligure7279473li_gure
likuta1034213li_kuta
limuli836343li_muli
linable92214343linable
lineal65616033lineal_
lineup835983lineu_p
lineups934913lineups
ling57447963ling___
lingam95112353ling_am
lingams104510193lingams
lingas75116573ling_as
lingcod1143683lingcod
linger75226003ling_er
lingers84223303lingers
lingier84113383lingier
lingo66022113ling__o
lingoes84014693lingoes
lings67135773ling__s
lingually1344373lingually
linguicas1243063linguicas
linguine937593linguine
linguini945533linguini
linguisas1043573linguisas
linguist948573linguist
lingy96925143ling__y
linkup1245123linku_p
linkups1333633linkups
lintel64013993lintel_
lintels73311163lintels
lintol6369473lintol_
lintols7339553lintols
linum7313823lin_u_m
linums838283lin_ums
longly10279603long_ly
lungful1144013lungful_
lungfuls1242773lungfuls
lunulae735613lun_ulae
lunular736013lun_ular
lunule638433lun_ule
lyingly14115263lying_ly
mingle93518783ming_le
pinguid1146243pinguid
pinnulae1044183pinnulae
pinnular1044433pinnular
pinnule936003pinnule
planula935773plan_ula
ranula6311813ran_ula
sigla64515203si_g_la
sinful938803sinful_
single74520603sing_le
singly104015853sing_ly
singulars10305633singulars
spinula9257903spin_ula
tinful938043tinful_
tinfuls1036593tinfuls
tingle74319073ting_le
tingly103815983ting_ly
ungual738183_ungual
ungulae837313_ungulae
ungular836773_ungular
virgule1144283virgule
zingara1745513zingara
zonula1537223zon_ula

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 Filter1786911340270.796224486.2
2DLD Change Limit1340271348.31316122.6
3Display Results1341340.0462913.0
 (SQL Overall)1786911349.15519518.4
 
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.