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 “linguam” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
lingam95112351ling_am
lingua7509911lingua_
linguae8398411linguae
lingual8379081lingual
gingham1484462gingham
linga66820822ling_a_
lingams104510192ling_ams
lingas75116572ling_as
linguals9317222linguals
lingula8428802lingula
lingulae9357032lingulae
lingular9407502lingular
linum7313822lin_u_m
bilingual1252433bilingual
cingula10327173cingula
cingular11256973cingular
cingulum1342723cingulum
diagram1147363diagram
dingbat1146983dingbat
dingus83611843dingu_s
dinkum1335893dinku_m
engram9310653_engram
gingal81010153ging_al
ginghams1573903ginghams
ingulf10310353_ingulf
inseam8329993_inseam
jingal1498593jing_al
kingdom1543543kingdom
language10105003language
langue71012173langu_e
langues81211913langues
languet8713693languet
languid936623languid
languor895423languor
langur7109303langu_r
langurs889103langurs
ligan67920283li_g_an
lignan75510323li_gnan
ligula7359673li_gula
ligulae8308753li_gulae
ligular8348533li_gular
ligulas8329173li_gulas
ligule74010833li_gule
ligure7279473li_gure
linac7315413lin__ac
lineal65616023lin_eal
linear65113343lin_ear
lineman939123lineman
lineup835983lineu_p
lineups934913lineups
ling57447963ling___
lingcod1143683lingcod
linger75226003ling_er
lingers84223303lingers
lingier84113383lingier
lingo66022113ling__o
lingoes84014693lingoes
lings67135773ling__s
lingually1344373lingually
linguica1143483linguica
linguicas1243063linguicas
linguine937593linguine
linguini945533linguini
linguisa944473linguisa
linguisas1043573linguisas
linguist948573linguist
lingulate10368193lingulate
lingy96925143ling__y
linkman1335393linkman
linkup1245123linku_p
linkups1333633linkups
linums838283lin_ums
logjam1635363l_ogjam
longan75612363long_an
lungan74710213lung_an
minicam131110063minicam
minium106014423miniu_m
pangram1239023pangram
pinguid1146243pinguid
ringtaw1154363ringtaw
singular9327563singular
tangram1038073tangram
ungual738183_ungual
wigwam1544723wi_gwam
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.393454684.5
2DLD Change Limit134027856.32621186.7
3Display Results85850.0332575.8
 (SQL Overall)178691856.75226464.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.