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 “quassins” 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
quassins173579(None) 
quassias1754931quassias
quassin1645941quassin_
quashing2137092quashing
quasses16209502quass_es
quassia1644792quassi_a
amassing1138003amassing
assassins843933assassins
assigns836193__assigns
basins85722763_ba_sins
biassing11307263biassing
brassies103613533brassies
brassing112612303brassing
buskins133310943bu_skins
bussing103614623bu_ssing
bussings11386663bu_ssings
caseins93115053_caseins
cassias93514343_cassias
cassina94113163_cassina
cassinas103610643_cassinas
cassine93817283_cassine
cassines103116613_cassines
cassino93512433_cassino
cassinos10309353_cassinos
cassis84818853_cassi_s
chassis123910663chassi_s
classics12418873classics
classing113211793classing
classis93712723classi_s
classons1037703classons
cussing103814273cu_ssing
dassies84418663_dassies
elastins82111743elastins
fuchsins16104263fuchsins
fusains1038363fu_sains
fussing113611683fu_ssing
gaskins123510773_gaskins
gassing94216333_gassing
gassings10438403_gassings
glassies94012273glassies
glassine9329313glassine
glassines10278043glassines
glassing10329973glassing
grassing103311973grassing
guanins8810013gua_nins
guessing1036243guessing
gussies82813303gu_ssies
hussies103213293hu_ssies
jasmins1637083_jasmins
jassids1586143_jassids
kamsins1346963_kamsins
khamsins1743393khamsins
lashins103915153_lashins
lassies74420103_lassies
lassis65216703_lassi_s
massifs1237743_massifs
massing104318023_massing
muslins9312213mu_slins
mussing104015543mu_ssing
oquassas1742113oquass_as
ouabains1044363ouabains
outsins73417863ou_tsins
passing104318423_passing
passings11409873_passings
passions10310583_passions
plasmins12199413plasmins
pussies93615693pu_ssies
quacking2436743quacking
quadding2035363quadding
quadrans1866363quadrans
quadrics2045653quadrics
quaffing2434353quaffing
quailing1838403quailing
quails153412643qua__ils
quaint15415173qua__int
quais144618393qua__i_s
quaking2139313qua_king
quantics19276833quantics
quanting1849233quanting
quarries1749943quarries
quartans1736283quartans
quartics19216843quartics
quasars1646903qua_sars
quashers20186803quashers
quashes192110973qua_shes
quasi144015023qua_si__
quass144413763qua_s__s
quatrains1845583quatrains
quayside2143473quayside
quaysides2243283quaysides
questing1838273questing
questions1845523questions
quinins162811293qu_inins
quins144819853qu___ins
quinsies1737623quinsies
quintins17329863quintins
quisling18218063quisling
quislings19184713quislings
quoins154110583qu__oins
raisins72715343_raisins
reassigns1074353reassigns
sasins64923103_sa_sins
sassies74719263_sassies
sassing84615553_sassing
squashing2234703squashing
suasions838783suasions
sussing84013703su_ssing
tassies74918933_tassies
tussis6379953tu_ssi_s
wussies103411083wu_ssies

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.54622328.4
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.99825534.6
 
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.