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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
cracking17401390(None) 
clacking173313491clacking
crackings18346841crackings
crackling18157001crackling
cranking154613071cranking
cricking173412651cricking
crocking174313441crocking
racking144323661_racking
tracking153715461tracking
wracking18349961wracking
arcking145811962ar_cking
backing165523442_backing
blacking174213602blacking
bracing123817612brac_ing
braking143917712bra_king
bricking173911402bricking
caching156317502c_aching
cackling172610942c_ackling
caking134624672c_a_king
calking144617782c_alking
carjacking2643542carjacking
carking144322852c_arking
casking144317352c_asking
chalking183310062chalking
charking183512612charking
checking20379202checking
chocking204011012chocking
chucking20379502chucking
clanking154313062clanking
clicking173610982clicking
clocking174312412clocking
clucking17429992clucking
coaching164011962coaching
coacting133412702coacting
cocking163619982c_ocking
craaling112711352craaling
crabbing15287932crabbing
cracklings19143522cracklings
cradling122411452cradling
crafting143710172crafting
cramming15339432cramming
cramping153411852cramping
cranching17278732cranching
craning103620302cra_ning
crankling16147292crankling
craping124018712cra_ping
crapping153911452crapping
crashing143512632crashing
crating103725202cra_ting
craving134015732cra_ving
crawling143110512crawling
crazing193914582cra_zing
creaking153414122creaking
croaking153712162croaking
crooking153611342crooking
flacking184311792flacking
franking164310862franking
frocking18309572frocking
gracing113216442grac_ing
hacking173720612_hacking
jacking214515262_jacking
knacking14296712knacking
lacking143821542_lacking
packing164420722_packing
pranking153813382pranking
pricking173212602pricking
quacking2436742quacking
racing95030532_rac_ing
raking114728422_ra_king
ranking124320882_ranking
recking144319922_recking
reracking1639312reracking
ricking143920232_ricking
rocking143619632_rocking
rucking143216672_rucking
sacking144122702_sacking
shacking184014082shacking
slacking153914132slacking
smacking173510762smacking
snacking153411702snacking
stacking154215082stacking
tacking144421482_tacking
thacking183110042thacking
tracing103720152trac_ing
trackings16247542trackings
traiking132511972traiking
tricking152714512tricking
trocking153612422trocking
trucking153310162trucking
whacking21377482whacking
wrecking18328152wrecking
wricking18349492wricking
yacking174315682_yacking

Search took 5 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 Filter1786911210590.390458182.1
2DLD Change Limit121059933.78032026.2
3Display Results93930.0332818.2
 (SQL Overall)178691934.20342515.1
 
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.