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

510 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
trifler10391215(None) 
rifler94014261_rifler
trifle94012881trifle_
trifled113711961trifled
triflers113110211triflers
trifles103814821trifles
triller74215891triller
bridler103811072bridler
drifter11348702drifter
driller84311882driller
friller104111742friller
grifter113810492grifter
griller84513352griller
rifer84721982_rif_er
riffler13328352_riffler
rifle85518332_rifle_
rifled104115002_rifled
riflers103512192_riflers
riflery13345802_riflery
rifles94217702_rifles
stifler102911472stifler
tailer63823732tai_ler
thriller1165552thriller
tiler56131022t_i_ler
tiller64222542t_iller
toiler63918282toi_ler
trailer73015392trailer
trawler104011902trawler
tricker134615522tricker
trier54328532tri__er
trigger9329162trigger
trilled84116312trilled
trillers83613492trillers
trimer85717152tri_mer
trimmer113610832trimmer
triolet73219522triolet
triple84215922triple_
tripled104113832tripled
triples94616872triples
triplet94319212triplet
triplex16447802triplex
tripper113711922tripper
triter65120592tri_ter
troffer13125862troffer
troller73913172troller
twirler10285202twirler
arider74717743ari_der
ariled75620323ari_led
baffler15418113baffler
bailer85425253bai_ler
biflex1834953_biflex
biller84923483_biller
birler85715083_birler
boiler84319273boi_ler
brailler1036883brailler
brawler124310233brawler
briber104714053bri_ber
bridle94115463bridle_
bridled113611143bridled
bridlers11359183bridlers
bridles104114473bridles
briefer1235563briefer
brier74527403bri__er
brimmer13348803brimmer
briner84519043bri_ner
bringer104213353bringer
brinier93613473brinier
brisker134210293brisker
brittler10165983brittler
broiler92911753broiler
ceiler84013963cei_ler
chiller124112183chiller
circler1136423circler
coiler84421593coi_ler
cradler102910513cradler
crafter124111333crafter
crawler123510463crawler
cribber13367663cribber
crier74724463cri__er
crimmer133310773crimmer
crimper136510423crimper
cringer103514243cringer
crippler14826713crippler
crisper113511053crisper
critter94113033critter
crofter12299573crofter
crueler939023crueler
cruller968753cruller
defiler113911883defiler
deifier113013123deifier
dialer74315433_dialer
differ133910843_differ
drafter11449423drafter
drawler11338593drawler
dribbler13316313dribbler
driblet103712243driblet
drier64423963dri__er
drifted12367953drifted
drifters12417913drifters
driftier1275123driftier
drilled94711673drilled
drillers9429723drillers
drinker12349483drinker
dripper12349233dripper
driveler1284693driveler
driver104714493dri_ver
droller84110283droller
edifier11309263edifier
eviler94811893evi_ler
eviller1056673eviller
exiler134712183exi_ler
fifer115519973_fif_er
filer85433003_fi_ler
filler94623623_filler
frailer10319943frailer
fribbler15265953fribbler
frier85225843fri__er
frilled113911603frilled
frillers11349873frillers
frillier1136513frillier
frisker14389273frisker
fritter103912773fritter
frivoler1443933frivoler
frizer184011283fri_zer
frizzer18446893frizzer
frizzler19345843frizzler
giller74519733_giller
girdler9227313girdler
grafter114211153grafter
gridder10367763gridder
griever1136033griever
griffe13438093griffe_
griffes14367923griffes
grifted12379583grifted
grifters12389233grifters
grille74315743grille_
grilled94012833grilled
grillers93810813grillers
grillery12355503grillery
grilles83715023grilles
grimier103210433grimier
grimmer123510093grimmer
grinder93312393grinder
grinner8329233grinner
griper94114613gri_per
gripier103210323gripier
gripper124410713gripper
grislier935793grislier
grister83915413grister
gritter83913353gritter
grizzler17335033grizzler
growler11318973growler
grueler837023grueler
gruffer1475793gruffer
hailer94720343hai_ler
heifer1238203heif_er
hiller94421633_hiller
idler65015663__idler
iller54821293__iller
jailer134316683jai_ler
killer104917953_killer
knifer13598563knif_er
krimmer15376873krimmer
kruller1145153kruller
lifer85822153_lif_er
lifter93814813_lifter
mailer84724183mai_ler
miler75733063_mi_ler
miller84625413_miller
moiler84017263moi_ler
muffler15398343muffler
nailer64119363nai_ler
niffer12378443_niffer
nitrifier1245963nitrifier
oiler54628283_oi_ler
oriole6814293oriole_
orioles7412993orioles
petrifier1447123petrifier
pilfer1139163_pilfer
prefer113813203pref_er
pricer103918293pri_cer
pricier113313113pricier
pricker154013413pricker
prier75027763pri__er
prilled104713003prilled
primer105118683pri_mer
primmer134310163primmer
prinker133412743prinker
printer93917303printer
privier122910453privier
prizer174714883pri_zer
proffer15126933proffer
profiler13287643profiler
prowler123310013prowler
purfler12248733purfler
purifier1338573purifier
raffler13339223raffler
rafter94517583_rafter
railer64524933_railer
realer63528593_realer
reeler63822573_reeler
refer84822143_ref_er
reflet94024233_reflet
reflew12389453_reflew
reflex16359513_reflex
reifier103414523reifier
ribber103515493_ribber
ribier84414233_ribier
riblet84222443_riblet
ricer74726613_ri_cer
richer114015043_richer
ridder84015143_ridder
riddler93411263_riddler
rider65231303_ri_der
ridley10169543_ridley
riever94811653_riever
rife74632323_rif_e_
rifely123710033_rifely
riffed133811563_riffed
riffle124210233_riffle_
riffled14338603_riffled
rifflers14336443_rifflers
riffles133911163_riffles
riflip1134723_riflip
rifted104115313_rifted
rigger85616713_rigger
rile45650533_ri_le_
riled65833253_ri_led
riles55343643_ri_les
riley84420583_ri_ley
rille55728733_rille_
rilled74525653_rilled
rilles64725503_rilles
rillet64828853_rillet
rimer75429243_ri_mer
rimier83916273_rimier
rimmer103516033_rimmer
ringer74526063_ringer
rinser64317213_rinser
rioter64817283_rioter
riper74328403_ri_per
ripper103518653_ripper
rippler113210103_rippler
riser55431053_ri_ser
risker105414493_risker
ritter63822423_ritter
river85731693_ri_ver
rolfer94412273_rolfer
roller63919793_roller
ruffler13369723ruffler
ruler54923343_r_uler
sailer63526103sai_ler
shifter132911083shifter
shriller1136823shriller
sidler74716963_sidler
sifter94516233_sifter
siller64026063_siller
smiler83916683smi_ler
sniffer13318903sniffer
sniffler14296833sniffler
snifter10349623snifter
spieler93111233spieler
spiller92914333spiller
stiffer13319393stiffer
stifle93611903stifle_
stifled113511093stifled
stiflers11238833stiflers
stifles103013393stifles
stiller73414303stiller
strafer103912463straf_er
stricter1039423stricter
strider84315723stri_der
strife95318363strif_e_
strifes104716583strif_es
striker113714173stri_ker
stringer93812943stringer
striper94514793stri_per
stripier1058863stripier
stripper1247123stripper
striver104315203stri_ver
stroller848183stroller
swifter13318053swifter
swiller103211663swiller
tackler134013323tackler
tailed74424663tai_led
tailers73720183tai_lers
taille63116923taille_
tailles72516473tailles
tailleur843303tailleur
tailor63412503tai_lor
taler56034863t__aler
taller63721963t_aller
tangler83515073tangler
tariffed1533723tariffed
tattler73112213tattler
telfer9379893telf_er
teller63519823t_eller
terrifier12126603terrifier
thaler94613103t_haler
thicker163611023thicker
thinker143610683thinker
thinner10358973thinner
thirled11328093thirled
thither13328103thither
thriftier1542853thriftier
thrilled1235493thrilled
thrillers1244473thrillers
thriver13479123thri_ver
thurifer1443273thurif_er
ticker124321503t_icker
tickler133612653tickler
tiddler93110003tiddler
tidier73515113t_idier
tier44936143t_i__er
tiffed13368393t_iffed
tiger65718633t_i_ger
tile45451443t_i_le_
tiled64832943t_i_led
tilers63523503t_i_lers
tiles55542103t_i_les
tilled74722953t_illed
tillers73418743t_illers
tilter63417693t_ilter
timber104012683t_imber
timer75626043t_i_mer
tinder73821803t_inder
tingler83613343tingler
tinier63622233t_inier
tinker103619923t_inker
tinkler113610543tinkler
tinner64119963t_inner
tinter63923643t_inter
tipper103918413t_ipper
tippler11348343tippler
tireder837703tireder
tirled74714363t_irled
titer55430613t_i_ter
titfer9409523t_itfer
tither94920283t_ither
title54721073t_itle_
titled73815003t_itled
titles63719923t_itles
titter63421163t_itter
toddler9379043toddler
toggler9399193toggler
toile54626493toi_le_
toiled74420323toi_led
toilers74116263toi_lers
toiles63923513toi_les
toilet66228093toi_let
toller63819443t_oller
tooler63818613t_ooler
tootler73511123tootler
tracer84820233tr_acer
tracker133515173tracker
trader75218763tr_ader
trailed83415673trailed
trailers82912923trailers
trainer73316793trainer
tramper113812163tramper
trampler12278013trampler
trapper113912803trapper
trasher104416133trasher
traveler11328433traveler
trawled113411523trawled
trawlers113310203trawlers
trawley13317303trawley
treader84113833treader
treadler936863treadler
treater74219833treater
treble8311663treble_
trebled1038483trebled
trebles9311443trebles
trekker1034733trekker
trembler1235363trembler
triable92515393triable_
triage72812893triage_
triaged92810443triaged
triages82613793triages
trial54926353trial__
trials64319883trial_s
tribe74420273tri_be_
tribes85119023tri_bes
trice75127493tri_ce_
triced95518673tri_ced
tricep103911073tri_cep
trices84826333tri_ces
tricked144016163tricked
trickers143812813trickers
trickery17297343trickery
trickier143010233trickier
trickle133613443trickle_
trickled152610433trickled
trickles143013763trickles
tricklier15256823tricklier
triclad1037443triclad
tricolor10115833tricolor
tried65026913tri__ed
triene64316383triene_
trienes74118413trienes
triers64321523tri__ers
tries55742813tri__es
trifid1039063trif_id
trifling122411503trifling
trifold1136243trifold
triform1237853triform
trigged10359853trigged
triggers10257843triggers
trigly103810943trigl_y
trijet133916553tri_jet
trike95320163tri_ke_
trikes105419493tri_kes
trilby1144973tri_lby
trill55122933tri_l_l
trills64319853tri_lls
trimers94615143tri_mers
trimeter10310083trimeter
trimly114410893triml_y
trimmed12348933trimmed
trimmers12288913trimmers
trindle83311363trindle_
trindled10388693trindled
trindles93211683trindles
trine54734603tri_ne_
trined74920713tri_ned
trines64132563tri_nes
trinket11314813trinket
triode75311893triode_
triodes84012503triodes
triol55521363triol__
triolets83410143triolets
triols66117803triol_s
triose64715383triose_
trioses75015653trioses
tripe75425383tri_pe_
tripes85324873tri_pes
triplets103510263triplets
triply114211023tripl_y
tripped123911693tripped
trippers123210163trippers
trippet113714113trippet
trippier1246623trippier
triste63818643triste_
trite54730033tri_te_
tritely1039003tritely
triune64210183triune_
triunes74311383triunes
trivet93721883tri_vet
troffers14125433troffers
trolled84312263trolled
trollers83211213trollers
trolley10328753trolley
trooper94210363trooper
trotter73312253trotter
troubler1035293troubler
trouper93811433trouper
trouser73812473trouser
trover95014663tr_over
troweler11106063troweler
trucker134010733trucker
truckler14297453truckler
trudger9338733trudger
truer54916643tr__uer
truffe1276233truffe_
truffes1356773truffes
truffle1384893truffle_
truffled1563993truffled
truffles1485593truffles
trundler9256153trundler
trusser74010263trusser
truster73114313truster
tryster10369513tryster
tufter9319933t_ufter
tuille63012643tuille_
tuilles72411923tuilles
tumbler113412823tumbler
tummler11266613tummler
turfier10249793turfier
turtler72610323turtler
twiddler13244873twiddler
twier84713293twi__er
twilled11398033twilled
twiner94012593twi_ner
twinier1037313twinier
twinkler1564073twinkler
twirled11385983twirled
twirlers11274303twirlers
twirlier1133513twirlier
twister10308953twister
twitter10278093twitter
twofer1234353twof_er
typifier1643403typifier
unifier102211863unifier
unrifled1237423unrifled
utricle937913utricle_
utricles1037223utricles
veiler93814353vei_ler
verifier14159203verifier
viler86324163_vi_ler
waffler16377783waffler
wailer93720323wai_ler
whiffer19105323whiffer
whiffler2033483whiffler
whirler13307603whirler
willer94021063_willer
wrier84521753wri__er
wriggler13295263wriggler
wringer113612453wringer
writer94416513wri_ter
writher134010853writher

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 Filter1786911340270.420425454.8
2DLD Change Limit1340275106.09621986.1
3Display Results5105100.1703000.0
 (SQL Overall)1786915106.68626726.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.