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

117 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
opaque173421(None) 
opaqued1942191opaqued
opaquer1842401opaquer
opaques1833641opaques
claque17338562claque
opaquely2241502opaquely
opaquest1943222opaquest
pique16410172_pique
plaque17317642plaque
ague55725923__ague
apace94718383apa_ce
apache134210783apache
aqua132813963__aqua
aquae142212713__aquae
barque17239553barque
basque17259083basque
bisque17257843bisque
bosque17257733bosque
caique17318803caique
calque17289843calque
casque17299273casque
cheque2036663cheque
cinque1736853cinque
cirque1735853cirque
claquer18287353claquer
claques18279013claques
clique17289193clique
cloque17288743cloque
copihue1444143copihue
fique1739143_fique
league758743league
macaque2044053macaque
manque17259513manque
maqui16249953_maqui
marque172410503marque
masque17249383masque
mosque17287163mosque
oakum1177313o_akum
oblique1844703oblique
omasum1035503omasum
opah96218403opa__h
opahs105411983opa_hs
opal66923523opa__l
opaline9412483opaline
opals75718353opa_ls
opaquing2042313opaquing
ope56845243op___e
ophite11410563ophite
opiate8513463opiate
opine77422463op_ine
opium92812093op_ium
oppose1039193oppose
optime1079353optime
opus66420593op__us
orache114013593orache
oracle84313293oracle
orange74016323orange
orate55133303ora_te
ovate84214393ova_te
pace86345773_pa_ce
padle84522343_padle
padre86018163_padre
page76036103_pa_ge
paise75028333_paise
pale66055013_pa_le
pane64950293_pa_ne
panne76623653_panne
papule102212133_papule
parae76335713_parae
pare66760843_pa_re
pareu74928743_pareu
parge85831853_parge
parle75836163_parle
parquet18311583_parquet
parse75236993_parse
parure8312523_parure
parve109824853_parve
pase65346863_pa_se
passe75525693_passe
paste74932953_paste
pate65350463_pa_te
pause75021833_pause
pave96133893_pa_ve
payee105524723_payee
piqued1836213_piqued
piques1739093_piques
piquet17412353_piquet
plague93610853plague
plaques18317893plaques
pulque1736213pulque
risque15227453risque
ropable111611333ropable
roque144812133_roque
sacque17107113sacque
space95325673spa_ce
spade84423323spa_de
spae65034323spa__e
spahee11313443spahee
spake114322743spa_ke
spale74929213spa_le
spare75135563spa_re
sparge94216053sparge
sparse84516343sparse
spate74731583spa_te
spathe115115693spathe
spavie113611383spavie
sprue74717633sp_rue
spue66025523sp__ue
statue66015323statue
toque145113093_toque
torque15237673torque
tuque14469193_tuque
ubique1784883ubique
unique1558163unique
usque14137733_usque
vague96513113_vague
value85719093_value

Search took 6 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 Limit1127161175.22021593.1
3Display Results1171170.0303900.0
 (SQL Overall)1786911175.62631761.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.