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

125 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
liquor153420(None) 
liquors1634431liquors
aliquot1646492aliquot
beliquor1942032beliquor
lictor83610862lictor
liqueur1642922liqueur
liquid1637142liquid
liquored1842882liquored
alienor7116303alienor
aliquots1743643aliquots
beliquors2042263beliquors
claquer18287353claquer
clique17289193cliqu_e
cliqued19266683cliqued
cliques18309203cliques
cliquey21295693cliquey
cliquier1944223cliquier
cliquy20324713cliqu_y
cruor7310453_cruor
dilutor8256013dilutor
diquat1639763diquat
faquir1834313faquir
fique1739143fiqu_e
fiques1837973fiques
fluor84512773_fluor
giaour735363giaour
ichor1039483_ichor
labor75117313l_abor
labour84210933labour
lacquer18135153lacquer
languor895423languor
lector83514993lector
lemur739773lemu_r
lessor64010603lessor
liar47229683li__ar
libber104414013libber
liber74723623li_ber
licker125222043licker
lictors93212603lictors
lidar6312723li_dar
lido56028163li_do_
lidos65219883li_dos
lieder74912323lieder
liefer9529573liefer
lier45942463li__er
lieu46534363lieu__
lieus56218483lieu_s
liever94611863liever
lifer85822153li_fer
lifter93814813lifter
liger65024473li_ger
ligula7359673ligula
ligular8348533ligular
ligule74010833ligule
ligure7279473ligure
liker95627063li_ker
likuta1034213likuta
lilo46731563li_lo_
lilos55821873li_los
limber104316793limber
limbo95614813limbo_
limbos104712143limbos
limier83518723limier
limmer104314793limmer
limner84112873limner
limo65529733li_mo_
limos75320813li_mos
limper104117853limper
limuli836343limuli
linear65113343linear
liner55938923li_ner
linger75226003linger
lingo66022113lingo_
linier64423793linier
linker104321473linker
lino46343373li_no_
linos55631503li_nos
linter64625343linter
lintol6369473lintol
linum7313823linu_m
linums838283linums
linuron746513linuron
lion46334443li__on
lipper104219633lipper
liquate1638423liquate
liquefy2243013liquefy
liqueurs1742413liqueurs
liquids1735823liquids
liquify2244033liquify
liquorice2052133liquorice
liquoring1943703liquoring
liquorish2152543liquorish
lirot5430033li_rot
lisper84114433lisper
lissom837403lissom
lister64527253lister
liter54736343li_ter
lither94520953lither
litho86513783litho_
lithos94212553lithos
litter64324853litter
litu47631563litu__
liver85132963li_ver
livier97514593livier
livyer12426293livyer
loquat1558283loquat
lour45430683l_ou_r
minor74920063mi_nor
mirror848003mirror
pique16410173piqu_e
piqued1836213piqued
piques1739093piques
piquet17412353piquet
quod145413623__quod
rigor62714053ri_gor
rigour7258023rigour
sieur5911893sieu_r
signor73510353signor
uniquer1675783uniquer
viator93211833viator
victor113210673victor
vigor92612423vi_gor
vigour10256803vigour
visor82512833vi_sor
vizor173010093vi_zor

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161255.64019985.1
3Display Results1251250.0801562.5
 (SQL Overall)1786911256.09629312.8
 
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.