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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

163 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
chant10593269(None) 
cant66362021c_ant
chang115418561chang
chants115020391chants
chanty145215821chanty
chapt125827641chapt
chart105038281chart
chat95546131cha_t
chaunt11613491chaunt
hant75461581_hant
alant55742292alant
ant37270782__ant
avant86224662avant
bhang115512922bhang
brant74742172brant
can57760132c_an_
cane66653112c_ane
cans65050842c_ans
canst74932212c_anst
canto74931012c_anto
cants77036942c_ants
canty105226802c_anty
cart66570342c_art
cast67159902c_ast
cat58282342c_a_t
cent67451012c_ent
chad105525502cha_d
chads116122232chads
chaeta11310682chaeta
chafe135117352chafe
chaff165016282chaff
chai95929902cha_i
chain105723672chain
chaine115119222chaine
chains114819702chains
chair105519632chair
chais107530312chais
chalet113825992chalet
chalk144814602chalk
chalot113020132chalot
cham115532312cha_m
champ145017962champ
chams126028502chams
chance134617092chance
chancy164010862chancy
change124116752change
changs125215372changs
chanted134015952chanted
chanter123919732chanter
chantey154112542chantey
chantor123710312chantor
chantry15388212chantry
chao95727312cha_o
chaos105622862chaos
chap114928492cha_p
chape125221142chape
chaps125326062chaps
char95132152cha_r
chard116124742chard
chare105231982chare
chark144222712chark
charm126124662charm
charr104821782charr
chars105936632chars
charts115823092charts
chary135023132chary
chase105127122chase
chasm125518792chasm
chaste114617392chaste
chats105730092chats
chatty14419362chatty
chaunts1267082chaunts
chaw126224632cha_w
chaws135022462chaws
chay124924872cha_y
chays135319742chays
cheat105732452cheat
chert105232102chert
chest104926142chest
chianti1236602chianti
chin96934742chin_
china105022472china
chine105231722chine
chink145321592chink
chino105823312chino
chins105631462chins
chints115117832chints
chintz204212022chintz
chit96937462ch_it
choana1138442choana
chon96627792chon_
chott103923922chott
chunk144812382chunk
clan65633922clan_
clang86019312clang
clank114719522clank
clans75031012clans
clapt98027172clapt
clast76030582clast
coact96130572coact
coapt96131522coapt
coast75236262coast
coat67558342coa_t
count74932052count
craft105327662craft
crane75331602crane
crank114819612crank
cunt66243672c_unt
cyan96419622cyan_
cyano105512492cyano
cyans105714812cyans
enchant12313102enchant
etchant1249812etchant
ghast95621222ghast
ghat86435282gha_t
ghaut95919432ghaut
giant65430592giant
grant64840022grant
haet75659502_haet
haft105941842_haft
haint85436322_haint
halt76056302_halt
hand86833702_hand
hang85535542_hang
hank115134132_hank
hants86335402_hants
hart76865772_hart
hast76259482_hast
hat67289962_ha_t
haunt85229132_haunt
haut75949732_haut
hent76656382_hent
hint77455742_hint
hunt76445492_hunt
khan115819142khan_
khans124615172khans
khat116730722kha_t
leant56737782leant
meant76537202meant
octant81216552octant
pant66061252_pant
phat95837862pha_t
plant75437112plant
quant143624812quant
rant45864672_rant
riant55833152riant
scant79735072scant
shaft115725252shaft
shalt85534482shalt
shank125422192shank
shanti94014072shanti
shanty124715112shanty
shat76456592sha_t
shent85933492shent
shunt85226502shunt
slant55238702slant
than76128772than_
thane86122532thane
thank125817802thank
that75639322tha_t
want76156162_want
whang124813382whang
what105434072wha_t

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001631.64032804.9
3Display Results1631630.0463543.5
 (SQL Overall)1786911631.779100444.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.