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

63 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
crackliest184488(None) 
crackles164111272crackl_es_
cracklier1744822cracklie_r
crankiest1538822crank_iest
crawliest14187402cra_wliest
crinkliest16104522crinkliest
freckliest1943382freckliest
hackliest1836522_hackliest
prickliest1845292prickliest
trickliest1646432trickliest
backlist16910653_backli_st
blacklist1746123blackli_st
brakiest143912243bra_k_iest
brambliest1643773brambliest
brawliest14177193bra_wliest
brickiest1737433brick_iest
cackles153717203c_ackl_es_
cakiest133215663c_a_k_iest
chalkiest1837093chalk_iest
checklist2043853checkli_st
clankiest1536673clank_iest
clerkliest1642793clerkliest
coaliest10316223coa__liest
cockiest163013293c_ock_iest
crabbiest1535623cra_bbiest
crackle153611253crackl_e__
crackled17428863crackl_e_d
crackling18157003crackli_ng
cracklings19143523cracklings
craftiest1436913cra_ftiest
craggiest13116523cra_ggiest
crampiest15268623cra_mpiest
crankest1438143crank__est
crankles143510153crankl_es_
crappiest15267273cra_ppiest
craziest19319923cra__ziest
creakiest15238593creak_iest
croakiest15167173croak_iest
crumbliest1643903crumbliest
crumpliest1644123crumpliest
darkliest1435163_darkliest
drawliest13166243dra_wliest
grackles15309183grackl_es_
knuckliest1542553knuckliest
prickiest1748183prick_iest
quackiest2435183quack_iest
raciest92820013_rac__iest
racketiest1643903_racketiest
rockiest142912223_rock_iest
scrabbliest1742483scrabbliest
scraggliest1542483scraggliest
scrawliest1553823scra_wliest
sickliest1547523_sickliest
sparkliest1644583sparkliest
tackiest143112433_tack_iest
trackless15246723trackl_ess
treacliest1245383treac_liest
trickiest1549023trick_iest
tricksiest1644353tricksiest
wackiest172610273_wack_iest
weakliest1635853wea_kliest
whackiest2144993whack_iest
wrinkliest1743833wrinkliest

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 Filter1786911406030.423422437.4
2DLD Change Limit140603635.92023750.5
3Display Results63630.0331909.1
 (SQL Overall)178691636.37628025.6
 
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.