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

102 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
linguals931722(None) 
lingual8379081lingual_
bilinguals1352402bilinguals
gingals9109312ging_als
jingals1588072jing_als
ligulas8329172li_gulas
lingams104510192ling_ams
lingas75116572ling_a_s
lingua7509912lingua__
linguae8398412lingua_e
lingually1344372lingually
lingula8428802lingu_la
lingulae9357032lingulae
lingular9407502lingular
ringhals1256262ringhals
annuals7388193_annuals
bilingual1252433bilingual_
cingula10327173cingu_la
cingular11256973cingular
congeals11309853congeals
dingbats1245013dingbats
dingus83611843dingu__s
dinguses1037643dinguses
finals94316163fin__als
finials103210153fin_ials
fungals11276783fung_als
gingal81010153ging_al_
gingall9117333ging_all
gingalls1096433gingalls
ginghams1573893ginghams
ingulf10310353_ingu_lf
ingulfs1134733_ingulfs
inhauls1035523_inhauls
instals7611713_instals
jingal1498593jing_al_
jingall1566173jing_all
jingalls1685333jingalls
langrels9106173langrels
language10105003language
languages11115053languages
langues81211913langu_es
languets987243languets
languors976153languors
langurs889103langu_rs
lanitals837723lanitals
legals73412733l_eg_als
liberals1039413liberals
ligans76817733li_g_ans
lignans8398853li_gnans
ligula7359673li_gu_la
ligulae8308753li_gulae
ligular8348533li_gular
ligule74010833li_gu_le
ligules82210923li_gules
ligures8269893li_gures
linacs8310813lin__acs
linalols844903linalols
lineal65616023lin_eal_
lineups934913lineu_ps
linga66820823ling_a__
lingam95112353ling_a_m
lingcods1243943lingcods
lingers84223303ling_ers
lingoes84014693ling_oes
lings67135773ling___s
linguica1143483linguica
linguicas1243063linguicas
linguine937593linguine
linguines1046513linguines
linguini945533linguini
linguinis1044283linguinis
linguisa944473linguisa
linguisas1043573linguisas
linguist948573linguist
linguists1045743linguists
lingulate10368193lingulate
linkups1333633linku_ps
lintels73311163lin_tels
lintols7339553lin_tols
linums838283lin_u_ms
literals8312293literals
longans84510813long_ans
longways1543873longways
lungans8399053lung_ans
lungfuls1242773lungfuls
manuals9311213man_uals
minerals10311373minerals
minimals12327433minimals
pineals93212843pin_eals
pingrass1146003pingrass
ringtails1044443ringtails
ringtaws1243563ringtaws
rituals738353ri_tuals
signals8359163si_gnals
singular9327563singular
singulars10305633singulars
tincals93610643tin_cals
tinfuls1036593tinfu_ls
ungual738183_ungual_
victuals1344773victuals
vinals94716483vin__als
visuals1036853vi_suals

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621027.73318901.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.95222471.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.