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

79 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
liaison74447(None) 
liaisons844291liaisons
liaise6310692liais_e
liaised837112liaised
liaises7311052liaises
liaising937912liaising
arson55118833__arson
basion84315853_basion
benison937123benison
bison75716983__bison
caisson936593caisson
chanson1238043chanson
classon937693classon
daikon11217243_daikon
daimon9259713_daimon
damson938063_damson
diapason1143623diapason
diatron839283diatron
diazinon1842203diazinon
division1266683division
divisor11345573divisor
elision72311103elisi_on
erasion7311963erasion
evasion1036753evasion
fission1038733fission
foison948933_foison
gibson935123gi_bson
grison7310103_grison
inion54620183_ini_on
ladron73413323l_adron
lagoon7410483l_agoon
lain46146283l_ai__n
lardon74415063l_ardon
lasso55015683l_asso_
lassos64913813l_assos
legion75712983legi_on
lesion64715063lesi_on
lesson64412043l_esson
lewisson1142023lewisson
lexicon1643903lexicon
liars54723163liars__
libation102411363libation
libido935753libido_
libidos1044653libidos
ligation92313093ligation
limacon1144143limacon
linin58025523lini__n
linuron746513linuron
lion46334443l__i_on
lipin75518893lipi__n
lissom837403li_ssom
logion76013723logi_on
lotion65716523loti_on
lyricon1243713lyricon
malison939693malison
mason74820183_ma_son
midiron1046003midiron
minion83416243mini_on
mission9312743mission
nasion63914083_nasion
orison6411663_orison
paisan84417073_paisan
parson83817903_parson
pinion83815893pini_on
poison8312223_poison
prison8514023_prison
raisin62716923_raisin
ramson8310463_ramson
reason62616333rea_son
season62714903sea_son
silicon9117533silicon
suasion739363suasion
unison649033_unison
venison1036443venison
vidicon1343783vidicon
virion9310683viri_on
vision9311313visi_on
warison1037083warison
weason93210823wea_son

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.406440125.6
2DLD Change Limit134027796.29621287.6
3Display Results79790.0302633.3
 (SQL Overall)178691796.73226543.5
 
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.