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

110 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
liquated183549(None) 
liquate1638421liquate_
liquates1737451liquates
equated171910402_equated
librated113110312librated
ligated92414142li_gated
ligulated11247362ligulated
lineated9711062lineated
liquidated2142792liquidated
liquored1842882liquored
sinuated938412sinuated
situated938032situated
actuated1138743actuated
alienated1047743alienated
antiquated2055483antiquated
arcuated1138803arcuated
ciliated11510953ciliated
citrated112712253citrated
cliqued19266683cliqu__ed
coequated2144823coequated
dictated1239203dictated
dilated93115823di_lated
diluted9248933dilu_ted
diquat1639763diquat__
diquats1745983diquat_s
disrated10915573disrated
equaled17166923_equaled
equate152012463_equate_
equates162012323_equates
filiated12610083filiated
fixated1835533fi_xated
ideated9310973_ideated
iodated9310023_iodated
labiated11109303labiated
lactated1138863lactated
lanated8313203l_anated
lariated91212063lariated
lated65240673l___ated
legated92513983l_egated
liberated1299473liberated
librate93214233librate_
librates103412953librates
lichted13268803li_chted
lifted104413523li__fted
ligate72519253li_gate_
ligates82318383li_gates
lighted122913503li_ghted
ligulate92510253ligulate_
lilted73715373li__lted
limbate1139213limbate_
limited102310233li_mited
lineate7815153lineate_
linted74021823li__nted
liquating1946313liquating
liquation1846553liquation
liquefied2242493liquefied
liquid1637143liqu__id
liquidate1943763liquidate_
liquidates2043373liquidates
liquified2244283liquified
listed74322833li__sted
litigated1146563litigated
lobated102610943l_obated
lobulated12106423lobulated
located103114183l_ocated
loculated1288313loculated
loquat1558283loquat__
loquats1645273loquat_s
louted74920693l_ou_ted
lunated8310823l_unated
lunted74517523l__unted
lunulated1036783lunulated
lusted74319443l__usted
luted64826143l__u_ted
luxated1535713l_uxated
lyrated11388473l_yrated
migrated121110513migrated
minuted10329503minu_ted
misdated121211123misdated
mismated131111333mismated
misquoted2144083misquoted
misrated111315383misrated
nictated1137793nictated
nidated939863ni_dated
nitrated92213153nitrated
picrated132110113picrated
pileated112711133pileated
pinnated11338553pinnated
piqued1836213piqu__ed
pirated102515613pi_rated
plicated13310643pli_cated
quaked203910033__quaked
quanted1738963__quanted
quate144521413__quate_
quoted16359453__quoted
requited18169723requited
roqueted1834653roqueted
simulated1238283simulated
sinuate7412163sinuate_
sinuates8310963sinuates
situate7410783situate_
situates8310373situates
squared173610563_squared
squatted1835343_squatted
titrated92611683titrated
unquoted1836533unquoted
valuated12239203valuated
vibrated14228393vibrated
violated1237883violated
vitiated12289223vitiated

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.406440125.6
2DLD Change Limit1461621106.76321612.0
3Display Results1101100.0502200.0
 (SQL Overall)1786911107.21924752.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.