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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

67 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
canonizer204669(None) 
canonize1959831canonize_
canonized2147681canonized
canonizers2144411canonizers
canonizes2049591canonizes
cannier94014162can_ni_er
canonise10511092canonise_
canonised1256712canonised
canonises11410802canonises
caponier1237882caponi_er
caponize2139112caponize_
caponized2347072caponized
caponizes2238702caponizes
colonizer20309282colonizer
agonize172911403_agonize_
agonized19258993_agonized
agonizes182610583_agonizes
anodize1738683_anodize_
anodized1946463_anodized
anodizes1837963_anodizes
anointer837823_anointer
atomizer19298533_atomizer
calorize192712733calorize_
calorized21249663calorized
calorizes202312293calorizes
canalize19914493canalize_
canalized21611693canalized
canalizes201113783canalizes
candider1237343can_dider
canner84625983can_n__er
cannie83819363can_ni_e_
cannister1155723can_nister
cannoneer1143923cannoneer
canoer85121073cano___er
canonic11312933canoni__c
canonical1347213canonical
canonist10513533canoni_st
canonists1158513canonists
canonizing2247713canonizing
canonries1148413canonries
canopied1336343canopi_ed
canopies12311853canopi_es
canyoneer1443413canyon_eer
caponiers1345733caponi_ers
carbonize22169043carbonize_
carbonized24157053carbonized
carbonizes23148613carbonizes
cognizer2055863c_ognizer
colonize192312773colonize_
colonized212710433colonized
colonizers21286723colonizers
colonizes202613183colonizes
colorizer202410623colorizer
conifer123212643c__onifer
conniver1337493con_niver
deionizer1945803deionizer
economizer2343693economizer
harmonizer24165423harmonizer
ionizer162310123__ionizer
lionizer1756053_lionizer
ozonizer1654473_ozonizer
paganizer2145763paganizer
pannier93613353pan_ni_er
randomizer2253083randomizer
sanitizer18126733sanitizer
unionizer1844623unionizer
vaporizer23236143vaporizer

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit148641676.37623312.6
3Display Results67670.0332030.3
 (SQL Overall)178691676.82926166.5
 
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.