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

106 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
liquids173582(None) 
liquid1637141liquid_
equids16439142_equids
lipids94310922li_pids
lipoids1038232lipoids
liquidly2143282liquidly
liquify2244032liquify
liquors1634432liquors
quids154917462__quids
soliquids1943522soliquids
squids16409802_squids
acquits1857293acquits
aliquots1743643aliquots
cliqued19266683cliqued_
cliques18309203cliqu_es
cliquier1944223cliquier
cliquiest2044093cliquiest
cliquing2035363cliquing
cliquish2244023cliquish
diacids1137863diacids
dioxids1655683dioxids
diquats1745983diquats
druids8368093_druids
equid154610323_equid_
equips17387193_equips
faquirs1943863faquirs
fiques1837973fiqu_es
fluids10349423_fluids
guids75516153__guids
illiquid1842643illiquid_
imids86015143_i_mids
iodids83711153_iodids
irids66417773_i_rids
kidvids1643113kidvids
lauds65618483l_au_ds
leuds66214813l_eu_ds
liards75212613li_ards
libido935753li_bido
libidos1044653li_bidos
lichis115212593lichi_s
lids56336463l___ids
lieus56218483lieu__s
ligands9438983ligands
lignins84010493lignins
ligulas8329173ligulas
ligules82210923ligules
ligures8269893ligures
lilies63021413li_lies
limits82514143li_mits
limpid11389753limpid_
limuloids1243183limuloids
limulus935083limulus
lindies8416583lindies
linins65922143li_nins
linums838283linu_ms
lipid85916173li_pid_
lipide93511063li_pide
lipides103810623li_pides
lipins85016883li_pins
lipoid9411043lipoid_
liquate1638423liquate
liquates1737453liquates
liquefies2153573liquefies
liquefy2243013liquefy
liqueur1642923liqueur
liqueurs1742413liqueurs
liquidate1943763liquidate
liquidates2043373liquidates
liquidity2243833liquidity
liquidize2852993liquidize
liquidizes2952863liquidizes
liquidness2042513liquidness
liquifies2144883liquifies
liquor1534203liqu_or
lithias1038823lithias
livid96714423li_vid_
lizards17427613lizards
loids66220703l__oids
loquats1645273loquats
louies64525103l_ouies
louis57322323l_oui_s
maquis17249483maqui_s
nitrids8269633nitrids
nonliquids2052163nonliquids
piqued1836213piqued_
piques1739093piqu_es
piquets1836603piquets
piquing1935873piquing
qaids156116313__qaids
quads154515843__quads
quid144922353__quid_
quins144819853__quins
quips164713373__quips
quits144122353__quits
quods154610223__quods
requins16310203requins
sequins1637863sequins
sialids839723sialids
silurids945103silurids
soliquid1844303soliquid_
squads164410293_squads
squibs17317453_squibs
squid154211903_squid_
tineids8337873tineids
toluids835323toluids
viroids1137923viroids

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 Filter1786911340270.440406115.9
2DLD Change Limit1340271067.20318607.1
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.68923239.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.