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

95 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
arcking14581196(None) 
arching136216691arching
arcing95819641arc_ing
racking144323661racking
aching126521972a_ching
acing87429152a_c_ing
acting95920982a_cting
arcading1239762arcading
archine125817052archine
archings14499862archings
arcsine94512392arcsine
argling92812732argling
arguing9248732arguing
arising83619972arising
arming94719802ar_ming
asking116017232a_sking
awaking1547812awaking
backing165523442backing
barking144724182bar_king
becking164416072becking
braking143917712braking
bricking173911402bricking
broking143514822broking
bucking163617572bucking
carking144322852car_king
cocking163619982cocking
cracking174013902cracking
cricking173412652cricking
crocking174313442crocking
darking134217342dar_king
decking153915592decking
dicking153617612dicking
docking153615012docking
ducking154315052ducking
erlking1236702erlking
farcing133514002farc_ing
frocking18309572frocking
fucking173212282fucking
gecking154111362gecking
hacking173720612hacking
harking154120942har_king
hocking173417242hocking
irking114611752ir_king
jacking214515262jacking
kecking134111882kecking
kicking133314022kicking
lacking143821542lacking
larking123718252lar_king
licking144118282licking
locking143718152locking
lucking143615832lucking
marching164312192marching
marking144020132mar_king
mocking163614452mocking
mucking163213822mucking
narking124015382nar_king
necking143913892necking
nicking143516322nicking
nocking143615112nocking
packing164420722packing
parching164313052parching
parking143423042par_king
pecking164017782pecking
picking163418332picking
pocking163916762pocking
pricking173212602pricking
racing95030532rac_ing
raking114728422_raking
ranking124320882ranking
recking144319922recking
ricking143920232ricking
rocking143619632rocking
rucking143216672rucking
ryking14348112_ryking
sacking144122702sacking
sicking143720172sicking
socking143518602socking
sucking143217412sucking
tacking144421482tacking
talcking1567082talcking
ticking143218752ticking
tracking153715462tracking
tricking152714512tricking
trocking153612422trocking
troking123514102troking
trucking153310162trucking
tucking143415182tucking
warking153519572war_king
wicking173414772wicking
wracking18349962wracking
wrecking18328152wrecking
wricking18349492wricking
yacking174315682yacking
yocking173712372yocking
yucking173211692yucking

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 Filter1786911076710.393454684.5
2DLD Change Limit107671953.78028484.4
3Display Results95950.0332878.8
 (SQL Overall)178691954.20642484.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.