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

89 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
truck11611546(None) 
cruck135615321cruck
ruck104728331_ruck
struck12489261struck
track114823011track
trick115420691trick
trock114817601trock
truce75118691truce
trucks124711971trucks
trunk94713041trunk
tuck104626571t_uck
amuck1389562amuck
brick134618152brick
brock136017072brock
brusk114912432brusk
buck125129902_buck
chuck164814872chuck
cluck134914892cluck
crack134120532crack
crick135118752crick
crock135921992crock
crucks144412582crucks
dreck124812802dreck
drunk10549842drunk
duck115929172_duck
eruct74022352eruct
frock145314652frock
fuck134924632_fuck
guck114922532_guck
huck135927632_huck
luck105329822_luck
muck125727852_muck
pluck134212302pluck
prick134317502prick
puck124927942_puck
rack106234882_rack
reck106130562_reck
rick107334652_rick
rock105735182_rock
rucks114422052_rucks
rusk85823312_rusk
shuck144314532shuck
snuck114411912snuck
strick124813202strick
stuck114515772stuck
suck106131732_suck
tack106536292t_ack
teuch105214852teuch
thack144915172thack
thick145613352thick
thunk124911852thunk
tick106231222t_ick
touch106519392touch
trace75829612trace
tracks124818842tracks
tract75635712tract
traik95418202traik
trank96222422trank
trek86222312tr_ek
trice75127492trice
tricks125319012tricks
tricky154211472tricky
troak95213572troak
trocks123614632trocks
truced95312052truced
truces84916332truces
trucked143910812trucked
trucker134010732trucker
truckle13358862truckle
true46725852tru_e
trued65117692trued
truer54916642truer
trues54925322trues
trug55720042tru_g
trugs65516802trugs
trull54012672trull
truly84111552truly
trump95615122trump
trunks10429752trunks
truss54916922truss
trust55426852trust
truth85214152truth
tucks114721122t_ucks
turk86125862t_urk
tusk85621632t_usk
wrack145413882wrack
wreck144611042wreck
wrick144013392wrick
yuck136423532_yuck

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.0802233637.5
2DLD Change Limit53800891.40638264.6
3Display Results89890.0302966.7
 (SQL Overall)178691891.516117870.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.