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

97 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
chancily184524(None) 
cannily1239262c_annily
chancel144011772chancel_
chancels15439082chancels
chancery18366652chancery
chancier1538822chancier
chancing162810282chancing
chancy164010862chanc__y
charily15310282cha_rily
chattily1634602chattily
chunkily2043082chunkily
crankily1755622crankily
fancily1538252_fancily
handily143610872_handily
bouncily1544383bouncily
cagily12411563c_a_gily
calcify1735873c_alcify
campily1638273c_ampily
cancel105316683c_ancel_
cancels114113313c_ancels
candidly1545213c_andidly
cattily123210853c_attily
chalcid1537883chalci_d
chalcids1635893chalcids
chally144314293cha__lly
chance134617093chanc__e
chanced154113213chanc_ed
chancer144215633chanc_er
chancers154313493chancers
chances145218093chanc_es
chanciest1638373chanciest
chancre14348783chanc_re
chancres15429363chancres
changing153211513changing
channel123910483channel_
channels13388493channels
chantey154112543chan_tey
chanties132615803chanties
chanting143413533chanting
chantry15388223chan_try
chanty145215823chan__ty
charcoaly19153173charcoaly
charity15311023cha_rity
chastely1635813chastely
chastity1645273chastity
cheekily2053473cheekily
cheerily1655423cheerily
cheesily1654413cheesily
chestily1645523chestily
chicly16429203ch_ic_ly
chillily1644113chillily
chinchy20335513chinc_hy
chirpily1843773chirpily
choicely1843823choicely
choppily2044133choppily
chubbily2042913chubbily
chummily2042843chummily
churchly2142973churchly
clammily1743633clammily
classily1336623classily
cornily12410853corn_ily
council1137473council_
councils1246973councils
crabbily1744343crabbily
crackly18397703cra_ckly
craftily1644783craftily
craggily1543703craggily
crankly16358123cran_kly
crazily2136923cra_zily
crunchily1943193crunchily
dandily12279633_dandily
fancify1834983_fancify
hackly18298733_ha_ckly
hammily1736063_hammily
happily1745763_happily
hardily143310273_hardily
hastily133010663_hastily
hazily2179063_ha_zily
lacily11612763_la_cily
lankily1437123_lankily
mangily1339753_mangily
manlily1238743_manlily
phonily1537103phon_ily
racily11715173_ra_cily
rancidly1444433_rancidly
saucily1237913_saucily
scantily1337583scantily
shabbily1873903shabbily
shadily1437723sha_dily
shaggily1643773shaggily
shakily1736903sha_kily
shinily13268933shin_ily
slangily1235383slangily
stanchly1644443stanchly
swankily1833833swankily
unhandily1643733unhandily
zanily18310183_zan_ily

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 Limit146162976.50022486.5
3Display Results97970.0462108.7
 (SQL Overall)178691976.96925640.8
 
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.