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

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

132 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
truckings1623502(None) 
trackings16247541trackings
trucking153310161trucking_
crackings18346842crackings
prickings18315652prickings
ruchings14287072_ruchings
rucking143216672_rucking_
shuckings19273852shuckings
tickings15368582t_ickings
tracings112910412trac_ings
tracking153715462tracking_
tricking152714512tricking_
trocking153612422trocking_
trucing103211842truc_ing_
trucklines1644292trucklines
truckling1645072truckling_
trussings10224032trussings
tucking143415182t_ucking_
wreckings19233682wreckings
archings14499863ar_chings
arcking145811963ar_cking_
backings174012213_backings
blackings18316763blackings
bracings13369293brac_ings
breakings16297063breakings
bricking173911403bricking_
brokings15317713br_okings
brucines1237763bruc_ines
brucins1158003bruc_in_s
bucking163617573_bucking_
caulkings1633353caulkings
chucking20379503chucking_
clucking17429993clucking_
couchings17285763couchings
cracking174013903cracking_
cracklings19143523cracklings
cricking173412653cricking_
crocking174313443crocking_
cruisings12214113cruisings
deckings16346683_deckings
drinkings15244773drinkings
drubbings15262883drubbings
ducking154315053_ducking_
ducklings17204013_ducklings
ductings12346673_ductings
erlkings1333563er_lkings
eructing112110173eructing_
flockings19314343flockings
frocking18309573frocking_
fucking173212283_fucking_
gruelings1163763gruelings
huskings16276043_huskings
lickings15298143_lickings
lucking143615833_lucking_
mucking163213823_mucking_
neckings15346113_neckings
packings174310063_packings
pickings17359383_pickings
plucking17357723plucking_
pricking173212603pricking_
racings105015133_rac_ings
racking144323663_racking_
rankings13389173_rankings
recking144319923_recking_
ricking143920233_ricking_
rocking143619633_rocking_
rocklings16224843_rocklings
rubbings13306333_rubbings
ruching133612933_ruching_
ruckling15258573_ruckling_
rulings83310383_ru_lings
runnings9326913_runnings
rushings12387843_rushings
sackings15389633_sackings
shucking18339433shucking_
smockings18264283smockings
stockings16296093stockings
streakings15235303streakings
sucking143217413_sucking_
sucklings16225113_sucklings
tacking144421483t_acking_
tacklings16235853t_acklings
takings124512573t__akings
talcking1567083talcking_
talkings13358403t_alkings
teachings15296553teachings
thacking183110043thacking_
thinkings17255053thinkings
thunking16196953thunking_
ticking143218753t_icking_
touching143211343touching_
tourings9277373tou_rings
tracing103720153trac_ing_
traiking132511973traiking_
trainings10246723trainings
trappings14265753trappings
trekking1235543trekking_
trichinas1446043trichinas
tricing103417353tric_ing_
trickiness1666353trickiness
trickling1647723trickling_
triflings13235973triflings
trimmings14254453trimmings
trippings14225723trippings
trithings13246603trithings
troaking133310973troaking_
troking123514103tr_oking_
trollings10286693trollings
truckage1543633truck_age
truckages1643523truckages
truckers14279013truck_ers
truckfuls1842463truckfuls
trucklers15295583trucklers
truckles14319383truck_les
truckline1544913trucklin_e
trucks124711973truck___s
trudging11266443trudging_
trueing83410183tru_eing_
truing73913933tru__ing_
trumping13308733trumping_
trussing9268653trussing_
trusting93411653trusting_
tubings10336483t_u_bings
tuftings12264323t_uftings
turnings9287233t_urnings
turtlings10184873turtlings
tusking124212063t_usking_
wickings18357183_wickings
wracking18349963wracking_
wrecking18328153wrecking_
wricking18349493wricking_
yucking173211693_yucking_

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411327.36020195.8
3Display Results1321320.0602200.0
 (SQL Overall)1786911327.84322783.5
 
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.