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

145 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
chancery1836665(None) 
chancer144215631chancer_
chancers154313491chancers
cancer104220922c_ancer_
cancers114018582c_ancers
cannery123610012c_annery
chance134617092chance__
chanced154113212chance_d
chancel144011772chance_l
chancels15439082chancels
chances145218092chance_s
chancier1538822chancier_
chancily1845242chancily
chancre14348782chanc_re
chancres15429362chancres
chancy164010862chanc__y
chandlery18384422chandlery
changer134215542changer_
changers144313202changers
chanter123919732chanter_
chanters134016742chanters
chantey154112542chante_y
chantry15388222chan_try
chattery16357272chattery
beanery1237563bean_ery
canary11314693c_an_ary
cancel105316683c_ance_l
cancels114113313c_ancels
cancered132411553c_ancered
caner75334773c_an_er_
caners84629203c_an_ers
canker124422523c_anker_
cankers134418753c_ankers
canner84625983c_anner_
canners93822663c_anners
canoer85121073c_anoer_
canoers94318373c_anoers
canonry1235923c_anonry
canter85230113c_anter_
canters94827733c_anters
cattery123811603c_attery
cautery12349593c_autery
chafer144714573cha_fer_
chafers154512743cha_fers
chaffer18389473chaffer_
chaffers19378003chaffers
chamber164011063chamber_
chambers173410623chambers
chamfer17399863chamfer_
chamfers18409223chamfers
champer163813413champer_
champers173311623champers
champerty2142883champerty
chanceful1942763chanceful
chancellery2152273chancellery
chancellory2151953chancellory
chanceries1747653chanceries
chanciest1638383chanciest
chancing162810283chancing
chandler14358373chandler_
chandlers15387673chandlers
change124116753change__
changed144214143change_d
changes134517583change_s
changeup1642683changeup
channel123910483channe_l
channels13388493channels
chanted134015953chante_d
chanteys16387493chanteys
chantor123710313chantor_
chantors133710263chantors
chanty145215823chan__ty
chapter144213853chapter_
chapters154012133chapters
charactery2043423charactery
charger133914063charger_
chargers144011323chargers
charier124317903charier_
charley15118273charle_y
charmer144913663charmer_
charmers154211333charmers
charry145012113cha__rry
charter123918303charter_
charters134115583charters
chary135023133cha___ry
chaser114918383cha_ser_
chasers123714923cha_sers
chastely1635813chastely
chaster124718503chaster_
chatter124416643chatter_
chatters134213953chatters
chaufer15347943chaufer_
chaufers16347303chaufers
chaunter1366393chaunter_
chaunters1455823chaunters
chawer144314413cha_wer_
chawers154412053cha_wers
cheery144913153ch__eery
chicanery19103053chican_ery
chiccory1742483chiccory
chicer134513603ch_icer_
chicory1735993ch_icory
chinchy20335513chinc_hy
choicely1843823choicely
choicer14197893choicer_
chunter123911483chunter_
chunters133910903chunters
cindery13429193c_indery
clanger104113493clanger_
clangers114312343clangers
clattery13378193clattery
concern113011963c_oncern
concert113325223c_oncert
cranberry1642813cranberry
cranker133612793cranker_
dancer94817613_dancer_
dancers103413093_dancers
deanery1137613dean_ery
enhancer1346683enhancer_
enhancers1445103enhancers
glancer103710073glancer_
glancers11408003glancers
hance105424153_hance__
hances115621283_hance_s
hander104526433_hander_
handers114224333_handers
hanger104023253_hanger_
hangers113120813_hangers
hanker134622093_hanker_
hankers144218133_hankers
hatchery19326383_hatchery
hennery1335303_hennery
lancer84319973_lancer_
lancers93616643_lancers
orangery12305543orangery
prancer113613383prancer_
prancers123210333prancers
shantey134210043shante_y
shinnery14305673shinnery
swannery1433553swannery
tannery10388663_tannery
thanker14309593thanker_
thankers15297833thankers
thundery1533823thundery
tracery12399793tra_cery

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621456.42022766.7
3Display Results1451450.0502900.0
 (SQL Overall)1786911456.89325923.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.