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

140 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
trucklers1529558(None) 
truckers14279011truck_ers
truckler14297451truckler_
truckles14319381truckle_s
bucklers16349502_bucklers
chucklers2034442chucklers
knucklers1483042knucklers
ruckles133414602_ruckle_s
sucklers14379962_sucklers
tacklers143010772t_acklers
ticklers14339302t_icklers
trackers143512852track_ers
trackless15246722trackless
trickers143812812trick_ers
trickles143013762trickle_s
truceless11235392truceless
trucker134010732truck_er_
truckle13358862truckle__
truckled15327312truckle_d
trundlers10215002trundlers
tuckers134014352t_uck_ers
brickles162810283brickle_s
buckers153517453_buck_ers
buckler154112033_buckler_
buckles153416093_buckle_s
cacklers163710703_cacklers
chuckler1935553chuckler_
chuckles1936803chuckle_s
crackers164111723crack_ers
crackles164111273crackle_s
crucifers1643333crucifers
crullers1047303cru_llers
duckers143214713_duck_ers
freckles17126383freckle_s
frockless1843453frockless
fuckers163611593_fuck_ers
grackles15309183grackle_s
gruelers936173gru_elers
gruellers1034183gruellers
grumblers14245023grumblers
hacklers173710303_hacklers
hecklers17357123_hecklers
huckles163612623_huckle_s
knuckler1383623knuckler_
knuckles1384453knuckle_s
krullers1234133kru_llers
luckless14265893_luckless
muckers153612803_muck_ers
muckles153413253_muckle_s
pluckers16316553pluck_ers
prickers163710673prick_ers
prickles162511093prickle_s
puckers153514673_puck_ers
rackers134320453_rack_ers
reckless14257973_reckless
rockers133916553_rock_ers
rockless14297293_rockless
ruckle124414583_ruckle__
ruckled144111033_ruckle_d
rufflers14347193_rufflers
rulers64317093_ru__lers
rumblers123610743_rumblers
runkles114111943_runkle_s
rustlers8339853_rustlers
shacklers18336033shacklers
shuckers17388133shuck_ers
sticklers15227393sticklers
strickles1567813strickle_s
strugglers12273063strugglers
suckers133717623_suck_ers
suckler133413093_suckler_
suckles134516743_suckle_s
suckless14288823_suckless
tackers134319623t_ack_ers
tackler134013323t_ackler_
tackles133816523t_ackle_s
tackless14419483t_ackless
tickers133617723t_ick_ers
tickler133612653t_ickler_
tickles133416853t_ickle_s
tinklers12298183t_inklers
touchers133611213touc_hers
traceless11228643traceless
tracers94917843trac__ers
trachles13311753trachle_s
tracker133515173track_er_
tracklayers2051823tracklayers
trailers82912923tr_ailers
tramplers13305883tramplers
trauchles1445493trauchle_s
travelers12266773travelers
trawlers113310203tr_awlers
treadlers1045893treadlers
trekkers1133803tr_ekkers
tremblers1334483tremblers
tricker134615523trick_er_
trickery17297343trick_ery
trickier143010233trickier_
trickle133613443trickle__
trickled152610433trickle_d
tricklier15256823tricklier_
tricksters16264763tricksters
tricolors11125803tricolors
triflers113110213tr_iflers
trillers83613493tr_illers
trochlears1543143trochlears
trochleas1444713trochleas
trollers83211213tr_ollers
troublers1135003troublers
trowelers12105263trowelers
truces84916333truc__e_s
truckages1643523truckages
trucked143910813truck_e_d
truckfuls1842463truckfuls
truckings16235023truckings
truckline1544913truckline
trucklines1644293trucklines
truckling1645073truckling
truckload1641973truckload
truckloads1751663truckloads
truckmen1643373truckme_n
trucks124711973truck___s
truculent1144383truculent
trudgers10256863tru_dgers
truffles1485593truffle_s
trundler9256153trundler_
trundles9278483trundle_s
trussers8348283tru_ssers
trusters83112263tru_sters
trustless955953trustless
truthless1244033truthless
tucker124316953t_uck_er_
tuckets134810333t_uck_ets
tumblers123110623t_umblers
tummlers12295703t_ummlers
turtlers8258203t_urtlers
tuskers113710043t_usk_ers
tuskless1234213t_uskless
twinklers1633063twinklers
wreckers17315973wreck_ers

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411406.11024327.5
3Display Results1401400.0632222.2
 (SQL Overall)1786911406.57927160.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.