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 “classifiers” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
classifiers164278(None) 
classifier1543851classifier_
classifies1555001classifie_s
clarifiers1544012cla_rifiers
classified1644282classifie_d
basifiers1445203_ba_sifiers
clarifier1446123cla_rifier_
clarifies1448633cla_rifie_s
classers104111833class___ers
classicisms1753473classicisms
classicists1553783classicists
classicizes2453303classicizes
classier10359083class__ier_
classiness12196313classi_ness
declassifies18152623declassifie_s
falsifiers1643233_falsifiers
gasifiers1344523_ga_sifiers
ossifiers1274883__ossifiers
reclassifies1782853reclassifie_s
assigners1044414__assigners
assisters936354__assisters
basifier1337314_ba_sifier_
basifies13310494_ba_sifie_s
beautifiers1662214beautifiers
calcifies1638924c_alcifie_s
carnifies1439894c_arnifie_s
casefies1339214c_a_sefie_s
cashiers13318884c_a_s_hiers
casimires1344694c_a_simires
cassimere1343704c_assi_mere
cassimeres1443594c_assi_meres
cassines103116614c_assi_ne_s
cassises103811744c_assi_se_s
ceasefires1562164cea_sefires
certifiers1545144c_ertifiers
chastisers1543174chasti_sers
chastities1545864chastitie_s
claimers12298744cla__i_mers
clarified1546974cla_rifie_d
clarities11312484cla_ritie_s
clashers134213994cla_s__hers
claspers124410914cla_s__pers
classer93614614class___er_
classes94717944class___e_s
classicals1443904classi_cals
classicism1664224classici_sm
classicist1445604classici_st
classicize2363784classici_ze
classicized2552994classicized
classics12418874class__i_cs
classiest11309544class__iest
classifiable1961704classifiable
classify1644694classif___y
classifying2053204classifying
classis93712724class__i__s
classisms13295524class__isms
classists11296244class__ists
classless1143844class__less
classmates1444504classmate_s
claviers1367104cla___viers
coalifies1439114coa_lifie_s
codifiers1555344c__odifiers
crossfires1543544cross_fires
crucifiers1743074c_rucifiers
declassified19142494declassifie_d
emulsifiers1651644emulsifiers
falsifier1544434_falsifier_
falsifies1545984_falsifie_s
gasifier1236274_ga_sifier_
gasifies1238694_ga_sifie_s
glassier9289084glass__ier_
glassies94012274glass__ie_s
glassines10278044glassi_ne_s
glassiness11245994glassi_ness
glassmakers1852284glassmakers
glasspapers1651554glasspapers
glorifiers1442594gl_orifiers
gratifiers1443864gra_tifiers
justifiers2043084_justifiers
lassies74420104_lass__ie_s
lassoers8338514_lass__oers
magnifiers1643814_magnifiers
misclassifies20101704misclassifie_s
mystifiers1843114_mystifiers
opacifiers1742514opa_cifiers
ossifier111196274__ossifier_
ossifies1177564__ossifie_s
pacifiers1645464_pa_cifiers
plasticizers2592394plasticizers
qualifiers2243334qua_lifiers
quantifiers2352504quantifiers
ratifiers1236454_ra_tifiers
reclassified1882674reclassifie_d
russifies1245444_russifie_s
salsifies1247254_salsifie_s
satisfiers1342714_satisfiers
scarifiers1544104sca_rifiers
subclassifies2061724subclassifie_s
tackifiers1942934_tackifiers
testifiers13124504_testifiers
unclassified1862264unclassifie_d
versifiers16154144_versifiers

Search took 10 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 Filter1786911488190.453394461.4
2DLD Change Limit1488191029.28016036.5
3Display Results1021020.0631619.0
 (SQL Overall)1786911029.79618241.2
 
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.