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

70 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
canceller136668(None) 
canceler12238911cance_ler
cancelled1456741cancelled
cancellers1445361cancellers
canaller1038952can_aller
canceled13279402cance_led
cancelers13247862cance_lers
catcaller1344812catcaller
chancellery2152272chancellery
chancellor1752912chancellor
concealer1368222concealer
marceller1345152marceller
annealer845503_annealer
cackler153812573ca_c_kler
cadelle1039923ca_delle_
cadelles1139973ca_delles
caller85125483ca___ller
cameleer1246033ca_meleer
canaille1048413canaille_
canailles1148283canailles
canalled1139583can_alled
canallers1137213can_allers
cancel105316683cance_l__
cancelable1644643cancelable_
canceling14310163canceling
cancelling1547213cancelling
cancellous1443643cancellous
cancels114113313cance_l_s
cancer104220923canc___er
cancered132411553cance_red
candler103516593can__dler
canella9310793can_ell_a
canellas10310563can_ellas
caroller1039203ca_roller
catcalled1444893catcalled
catcallers1443803catcallers
caviller1337063ca_viller
chancellors1852683chancellors
chancellory2151953chancellory
chandelier1654293chandelier
chandelle1545223chandelle_
chandelled1744273chandelled
chandelles1645343chandelles
channeler1444603channe_ler
channelled1644143channelled
chiseller1443973chiseller
compeller1546293compeller
concealed1458133concealed
concealers1476913concealers
conceder1338743conce_der
conceiver1657413conceiver
concenter13312213concenter
congealer1256703congealer
crueller1056453c_rueller
cupeller1256103c_upeller
enameller1144173enameller
hanselled1345483hanselled
labeller10248083la_beller
lancelet1049473lance_let
marcelled1445203marcelled
marcellers1443833marcellers
nacelle938153na_celle_
nacelles1048393na_celles
panelled1138963pan_elled
parcelled1445783parcelled
penciller1344953penciller
raveller11339263ra_veller
sneller73512853_sn_eller
spancelled1543003spancelled
tunneller963893tunneller

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 Filter1786911486410.440406115.9
2DLD Change Limit148641707.43619989.4
3Display Results70700.0302333.3
 (SQL Overall)178691707.90622601.9
 
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.