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

146 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
chanciest163837(None) 
canniest10313362c_anniest
chaffiest2045412chaffiest
chalkiest1837082chalkiest
chances145218092chanc_es_
chancier1538822chancie_r
chanciness1745122chanciness
chancres15429362chancres_
chanties132615802chanties_
chariest13315502cha_riest
charriest1438252charriest
chattiest1448202chattiest
chinchiest2044412chinchiest
chinkiest1867022chinkiest
chunkiest1835262chunkiest
clankiest1536662clankiest
crankiest1538822crankiest
fanciest133612712_fanciest
handiest123417772_handiest
ancient9514733__ancient
bounciest1346433bounciest
branchiest1746713branchiest
branniest11199383branniest
cagiest102916433c_a_giest
cakiest133215663c_a_kiest
campiest142212133c_ampiest
candidest1346533c_andidest
candies104125613c_andies_
canoeist10310693c_anoeist
catchiest1638313c_atchiest
cattiest103016333c_attiest
chalcids1635893chalcids_
chalices15310813chalices_
challies133915643challies_
chammies172910163chammies_
chance134617093chanc_e__
chanced154113213chanc_e_d
chancel144011773chanc_e_l
chancels15439083chanc_els
chancer144215633chanc_e_r
chanceries1747653chanceries_
chancers154313493chanc_ers
chancery18366653chanc_ery
chancily1845243chanci_ly
chancing162810283chanci_ng
chancre14348783chancre__
changes134517583chan_ges_
chantries14310293chantries_
chappies172610093chappies_
charlies133414233charlies_
chartist131112133charti_st
chastest1349703cha_stest
cheekiest1835703cheekiest
cheeriest1438213cheeriest
cheesiest1436323cheesiest
chertiest1438793chertiest
chestiest1438313chestiest
chewiest16177293ch_ewiest
chicest14209943ch_ic_est
chichiest1936343chichiest
chilliest14358913chilliest
chinches18369363chinches_
chintziest2443253chintziest
chippiest18256803chippiest
chirpiest16286473chirpiest
choicest15226453choic_est
chokiest1738723ch_okiest
choosiest1437323choosiest
choppiest18226373choppiest
chromiest1637783chromiest
chubbiest1843753chubbiest
chuffiest2044403chuffiest
chummiest1834643chummiest
churchiest2044053churchiest
clammiest1535733clammiest
classiest11309543classiest
clayiest1337913cla_yiest
cleanliest1244353cleanliest
clingiest1257133clingiest
clunkiest1535163clunkiest
coaliest10316223coa_liest
concisest1348253c_oncisest
corniest102117303corn_iest
crabbiest1535623crabbiest
craftiest1436913craftiest
craggiest13116523craggiest
crampiest15268613crampiest
cranches153114543cranches_
crankest1438143cran_kest
crannies10313013crannies_
crappiest15267263crappiest
crawliest14187403crawliest
craziest19319923cra_ziest
crunchiest1764793crunchiest
dandiest103415033_dandiest
fancies124018783_fancies_
hairiest11612463_hairiest
hammiest152610003_hammiest
hances115621283_hanc_es_
hangnest12311413_hangnest
hankies143617763_hankies_
happiest152411673_happiest
hardiest123416333_hardiest
hastiest112916493_hastiest
haziest193313003_ha_ziest
hinkiest153311753_hinkiest
hunkiest153812333_hunkiest
jounciest1844613jounciest
laciest93819033_la_ciest
lankiest122912493_lankiest
mangiest112815903_mangiest
manliest102314943_manliest
minciest122913113_minciest
nancies93516843_nancies_
orangiest1038463orangiest
paciest112917803_pa_ciest
phoniest132811533phon_iest
raciest92820013_ra_ciest
randiest93418773_randiest
rangiest93115983_rangiest
sandiest93218683_sandiest
sauciest10310973_sauciest
scantiest112611003scantiest
shabbiest1635323shabbiest
shadiest121711273sha_diest
shaggiest14156893shaggiest
shakiest151910933sha_kiest
shaliest111415053sha_liest
shandies122714103shandies_
shannies113411253shannies_
shanties113116583shanties_
shiniest113212493shin_iest
skankiest12145703skankiest
slangiest10129073slangiest
spaciest122310893spa_ciest
stanchest14218213stanchest
swankiest16136203swankiest
tangiest92915223_tangiest
thatchiest1844163thatchiest
twangiest1355223twangiest
unhandiest1444603unhandiest
waniest103819113_wan_iest
whackiest2144983whackiest
whiniest14298753whin_iest
whinniest15245133whinniest
zaniest163214773_zan_iest

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.610292936.1
2DLD Change Limit1486411467.04621095.8
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.71923149.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.