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

205 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
truckler1429745(None) 
trucker134010731truck_er
truckle13358861truckle_
truckled15327311truckled
trucklers15295581trucklers
truckles14319381truckles
buckler154112032_buckler
chuckler1935552chuckler
knuckler1383622knuckler
ruckle124414582_ruckle_
ruckled144111032_ruckled
ruckles133414602_ruckles
suckler133413092_suckler
tackler134013322t_ackler
tickler133612652t_ickler
tracker133515172track_er
tricker134615522trick_er
trickier143010232trickier
trickle133613442trickle_
trickled152610432trickled
trickles143013762trickles
tricklier15256822tricklier
trucked143910812truck_ed
truckers14279012truck_ers
truckmen1643372truckmen
trundler9256152trundler
tucker124316952t_uck_er
brickier16307163brickier
brickle15279933brickle_
brickles162810283brickles
brusker13437853brusk_er
bucker145420463_buck_er
buckle144815193_buckle_
buckled164411883_buckled
bucklers16349503_bucklers
buckles153416093_buckles
cackler153812573_cackler
chuckle1836443chuckle_
chuckled2045163chuckled
chucklers2034443chucklers
chuckles1936803chuckles
cracker153114173crack_er
crackle153611253crackle_
crackled17428863crackled
crackles164111273crackles
cracklier1744823cracklier
crucifer1543683crucifer
crueler939023cru_eler
crueller1056453crueller
cruller968753cru_ller
drunker12326633drunk_er
ducker134317993_duck_er
duckier143911793_duckier
fickler16348423_fickler
freckle16106643freckle_
freckled18104443freckled
freckles17126383freckles
frecklier1842993frecklier
fucker153414423_fuck_er
grackle14338893grackle_
grackles15309183grackles
grueler837023gru_eler
grueller935333grueller
grumbler13866683grumbler
hackler163512353_hackler
heckler16278573_heckler
huckle153913073_huckle_
huckles163612623_huckles
knuckle1254233knuckle_
knuckled1463563knuckled
knucklers1483043knucklers
knuckles1384453knuckles
knucklier1442303knucklier
kruller1145153kru_ller
luckier133811533_luckier
mickler153310233_mickler
mucker143816393_muck_er
muckier153411483_muckier
muckle143413583_muckle_
muckles153413253_muckles
plucker15368243pluck_er
pluckier16295073pluckier
pricker154013413prick_er
prickier16368143prickier
prickle153611013prickle_
prickled17358073prickled
prickles162511093prickles
pricklier17245063pricklier
pucker143817633_puck_er
racker124824553_rack_er
rackle123917293_rackle_
rocker124319573_rock_er
rockier134911883_rockier
rucked134718763_ruck_ed
ruffler13369723_ruffler
ruler54923343_ru__ler
rumbler113514113_rumbler
runkle103611543_runkle_
runkled12399013_runkled
runkles114111943_runkles
rustler73512343_rustler
shackler17317973shackler
shucker163710103shuck_er
stickler14259573stickler
strickle1467793strickle_
strickled1665833strickled
strickles1567813strickles
strucken1444323struck_en
struggler11264553struggler
sucker124120663_suck_er
suckier133613973_suckier
suckle124015963_suckle_
suckled144212513_suckled
sucklers14379963_sucklers
suckles134516743_suckles
tacker124224503t_ack_er
tackier133712523t_ackier
tackle123815733t_ackle_
tackled143913193t_ackled
tacklers143010773t_acklers
tackles133816523t_ackles
thicker163611023thick_er
ticker124321503t_ick_er
tickle124616743t_ickle_
tickled144313133t_ickled
ticklers14339303t_icklers
tickles133416853t_ickles
tinkler113610543t_inkler
toucher124814353touc_her
touchier1347383touchier
tracer84820233trac__er
trachle12311853trachle_
trachled1438313trachled
trachles13311753trachles
tracked143716133track_ed
trackers143512853track_ers
tracklayer1942493tracklayer
trackless15246723trackless
trackmen1635573trackmen
trailer73015393tr_ailer
trampler12278013trampler
trauchle1344963trauchle_
trauchled1543733trauchled
trauchles1445493trauchles
traveler11328433traveler
trawler104011903tr_awler
treadler936863treadler
trekker1034733tr_ekker
trembler1235363trembler
tricked144016163trick_ed
trickers143812813trick_ers
trickery17297343trick_ery
trickie132611033trickie_
trickly16369893trickl_y
tricksier15275243tricksier
trickster15265703trickster
tricolor10115833tricolor
trifler103912153tr_ifler
triller74215893tr_iller
trochlea1345193trochlea
trochlear1443453trochlear
trocked144312243trock_ed
troller73913173tr_oller
troubler1035293troubler
troweler11106063troweler
truce75118693truc__e_
truced95312053truc__ed
truceless11235393truceless
truces84916333truc__es
truck116115463truck___
truckable1744513truckable_
truckage1543633truckage
truckages1643523truckages
truckful1743073truckful
trucking153310163trucking
truckline1544913truckline
trucklines1644293trucklines
truckling1645073truckling
truckload1641973truckload
truckman1643153truckman
trucks124711973truck__s
truculent1144383truculent
trudger9338733tru_dger
truer54916643tru___er
truffle1384893truffle_
truffled1563993truffled
truffles1485593truffles
trundle8307873trundle_
trundled10306393trundled
trundlers10215003trundlers
trundles9278483trundles
trunked12358413trunk_ed
trusser74010263tru_sser
truster73114313tru_ster
trustier8268683trustier
tucked134017493t_uck_ed
tuckers134014353t_uck_ers
tucket124219483t_uck_et
tumbler113412823t_umbler
tummler11266613t_ummler
turtler72610323t_urtler
tusker104212193t_usk_er
twinkler1564073twinkler
wrecker16367603wreck_er
yuckier16358533_yuckier

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622058.28317646.0
3Display Results2052050.0762697.4
 (SQL Overall)1786912058.79520317.3
 
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.