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

135 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
lingual837908(None) 
lingua7509911lingua_
linguae8398411linguae
linguals9317221linguals
lingula8428801lingula
bilingual1252432bilingual
cingula10327172cingula
gingal81010152ging_al
jingal1498592jing_al
ligula7359672li_gula
lineal65616022lin_eal
linga66820822ling_a_
lingam95112352ling_am
lingas75116572ling_as
lingually1344372lingually
lingulae9357032lingulae
lingular9407502lingular
ungual738182_ungual
annual64710703_annual
biannual1043323biannual
bilinguals1352403bilinguals
binal75323823bin__al
binaural1045413binaural
censual937663censual
cingular11256973cingular
clinal8311553clin__al
clinical1247023clinical
congeal104011683congeal
dingbat1146983dingbat
dingus83611843dingu_s
figural1145243fi_gural
final83922033fin__al
finial92814183fin_ial
finical1239693finical
fungal10388733fung_al
gingall9117333gingall
gingals9109313ging_als
gingham1484453gingham
gingival1342943gingival
hangul1049213hangu_l
incudal1045863_incudal
inguinal945603_inguinal
ingulf10310353_ingulf
inhaul936803_inhaul
instal6712193_instal
jingall1566173jingall
jingals1588073jing_als
langrel8107033langrel
language10105003language
langue71012173langu_e
langues81211913langues
languet8713693languet
languid936623languid
languor895423languor
langur7109303langu_r
langurs889103langurs
lanital7310913lanital
legal65715943l_eg_al
liberal9310193liberal
lienal63912783li_enal
ligan67920283li_g_an
lignan75510323li_gnan
ligulae8308753li_gulae
ligular8348533li_gular
ligulas8329173li_gulas
ligule74010833li_gule
ligure7279473li_gure
liminal93810673liminal
linac7315413lin__ac
linalol745093linalol
linear65113343lin_ear
lineman939123lineman
lineup835983lineu_p
lineups934913lineups
ling57447963ling___
lingams104510193lingams
lingcod1143683lingcod
linger75226003ling_er
lingers84223303lingers
lingier84113383lingier
lingo66022113ling__o
lingoes84014693lingoes
lings67135773ling__s
linguica1143483linguica
linguicas1243063linguicas
linguine937593linguine
linguini945533linguini
linguisa944473linguisa
linguisas1043573linguisas
linguist948573linguist
lingulate10368193lingulate
lingy96925143ling__y
linkman1335393linkman
linkup1245123linku_p
linkups1333633linkups
lintel64013993lin_tel
lintol6369473lin_tol
linum7313823lin_u_m
linums838283lin_ums
literal7613273literal
litoral7610763litoral
longan75612363long_an
lungan74710213lung_an
lungful1144013lungful
lunula636173lun_ula
manual8313463man_ual
mineral9312733mineral
minimal114010603minimal
pineal84817683pin_eal
pinguid1146243pinguid
pinnal84814273pin_nal
pinnula934913pinnula
ringhals1256263ringhals
ringtail944723ringtail
ringtaw1154363ringtaw
ritual6310623ri_tual
sensual738053sensual
signal73711483si_gnal
sinful938803sinfu_l
singular9327563singular
sublingual1352303sublingual
tincal83913363tin_cal
tineal66216163tin_eal
tinful938043tinfu_l
tissual745193tissual
trilingual1151763trilingual
ungula737603_ungula
unilingual1152063unilingual
victual1246253victual
vinal85725813vin__al
vincula1246393vincula
vineal94814743vin_eal
virtual1045913virtual
visual938803vi_sual
wingman1336383wingman

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271355.83022989.2
3Display Results1351350.0632142.9
 (SQL Overall)1786911356.04629555.2
 
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.