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

118 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
opaques183364(None) 
opaque1734211opaque_
opaqued1942191opaqued
opaquer1842401opaquer
opaquest1943221opaquest
claques18279012claques
opaquely2241502opaquely
piques1739092_piques
plaques18317892plaques
agues64919053__agues
apaches143411843apaches
aquas142412613__aquas
barques18259643barques
basques18248673basques
bisques18236893bisques
bosques18217973bosques
caiques18248793caiques
calques182710193calques
casques18278983casques
cheques2136863cheques
cinques1837333cinques
cirques1836463cirques
claque17338563claque_
claquer18287353claquer
claquers19226203claquers
cliques18309203cliques
cloques18268563cloques
copihues1543993copihues
fiques1837973_fiques
leagues837943leagues
macaques2143953macaques
maquis17249483_maquis
marques182610863marques
masques18239363masques
mosques18256923mosques
nopales93812523nopa_les
oakums1264153o_akums
oases55330983o_a_ses
oaves84925613o_a_ves
obliques1944523obliques
opahs105411983opa__hs
opalines10311423opalines
opals75718353opa__ls
opaqueness2142343opaqueness
opaquing2042313opaquing
opes65942613op___es
ophites12310103ophites
opiates9312143opiates
opines84820703op_ines
opiums10307073op_iums
opposes1149243opposes
optimes1148473optimes
opus66420593op__u_s
opuses84012243op_uses
oraches124216473oraches
oracles93212423oracles
oranges84215333oranges
orates64328613ora_tes
ovaries10312653ovaries
paces96741113_pa_ces
padles95221123_padles
padres95016983_padres
pages85235073_pa_ges
pales75753803_pa_les
panes76148693_pa_nes
pannes85522853_pannes
papules112411573_papules
pares77164483_pa_res
pareus85420743_pareus
parges94529543_parges
paries84742513_paries
parles86334403_parles
parquet18311583_parquet
parquets1936413_parquets
parses85534703_parses
parures9512693_parures
pases75346503_pa_ses
pashes115828393_pashes
passes86030473_passes
pastes85233913_pastes
pates76047893_pa_tes
pause75021833_pa_use
pauses84621473_pauses
paves104833923_pa_ves
paxes144928423_pa_xes
payees114812903_payees
pique16410173_pique_
piqued1836213_piqued
piquet17412353_piquet
piquets1836603_piquets
plagues103311063plagues
plaque17317643plaque_
poaches144416943poaches
pulques1835323pulques
roques154912563_roques
sacques18106863sacques
spaces104722633spa_ces
spades94222583spa_des
spaes76029973spa__es
spahees1238263spahees
spales84728103spa_les
spares84834553spa_res
sparges104016343sparges
spates85028173spa_tes
spathes125116533spathes
spavies123012953spavies
spazzes1735263spazzes
sprues84515763sp_rues
spues75025383sp__ues
statues74614903statues
topazes1857313topa_zes
toques154612353_toques
torques16217513torques
tuques15358373_tuques
uniques1667443uniques
upases84112903upa_ses
usques15126803_usques
values94314943_values

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.406440125.6
2DLD Change Limit1340271187.22018563.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.67223291.3
 
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.