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

288 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
pistou8321184(None) 
pistol83313331pistol
piston83515921piston
pistous92714381pistous
pastor84817482pastor
pesto75723722pesto_
pestos84719082pestos
pinto75625752pinto_
pintos86021292pintos
pisco96314982pisco_
piscos105112592piscos
piso66727562pis_o_
pisos76021062pis_os
piste75824602pist_e
pistes85325632pistes
pistil83915072pistil
pistole92414312pistole
pistols93213982pistols
pistons93016372pistons
piton76121582pi_ton
postop10511942postop
aristo6414033aristo_
aristos7312373aristos
bestow1149463bestow
bijou1458793bi_jou
bishop1336943bishop
bison75716983bis_on
bister84922763bister
bistort91216523bistort
bistoury1343413bistoury
bistre83815023bistre
bistro8339943bistro
bistros92810983bistros
boston8513043boston
bristol937043bristol
castor84418533castor
cestoi84511953cestoi
cestos84718093cestos
cisco95112133cisco_
ciscos104711133ciscos
cist67244963cist__
cisted95217523cisted
cistron9299883cistron
cists76624533cist_s
cistus84611343cistus
custom104010273custom
custos84014313custos
diatom939453diatom
disco85616073disco_
discos94915213discos
distal73615773distal
distil73616433distil
distome10313233distome
distort81120333distort
ditto65315603ditto_
dittos74111973dittos
epistle957893epistle
epistome1246263epistome
estop74312103_estop
fist76248423fist__
fisted104218703fisted
fistful1365903fistful
fistic11812573fistic
fists85527543fist_s
gismo848863gismo_
gismos957183gismos
gist56046763gist__
gists66026193gist_s
gusto65414643gusto_
hist76551543hist__
histed104420243histed
histoid1139823histoid
histone10312843histone
history1339423history
hists86328373hist_s
into45026153_into_
istle52214713_istle
kist86540803kist__
kistful1465303kistful
kists95822113kist_s
lictor83610853lictor
lintol6369473lintol
lissom837403lissom
list47055343list__
listed74322833listed
listee64223063listee
listel64214743listel
listen64816813listen
lister64527253lister
lists56628693list_s
litu47631563li_t_u
miaou7513083mi_aou
misdo85413183misdo_
miso67229903mis_o_
misos76523293mis_os
missout9412663missout
misstop11156413misstop
mist66154533mist__
mistbow1443993mistbow
misted93625823misted
mister84728563mister
misteuk1335893misteuk
mistook1337153mistook
mistouch1543793mistouch
mists76633903mist_s
misty106120453mist_y
nestor63713423nestor
niton55418283ni_ton
nostoc868193nostoc
panto76129413panto_
pantos85222743pantos
pantoum1138703pantoum
parton84720993parton
paseo77022513paseo_
paseos88015813paseos
past65959013past__
pasta76624533past_a
pastas85422873pastas
paste74932953past_e
pasted94426903pasted
pastel85918713pastel
paster85734373paster
pastes85233913pastes
pasteup1134983pasteup
pastie85525523pastie
pastil85018323pastil
pastis84924323pastis
pastors94119003pastors
pastry114913033pastry
pasts75936503past_s
pasty105725053past_y
peso66925823pes_o_
pesos77221623pes_os
pest65555293pest__
pester84827593pester
pestle83215843pestle
pests75933273pest_s
pesty106421713pest_y
petto76021043petto_
photo104417233photo_
photog12379813photog
photon1111514833photon
photos113316643photos
phytol14366563phytol
phyton143610253phyton
piano76118713piano_
pianos84315933pianos
piaster93012883piaster
piastre9307893piastre
piceous11310693piceous
picot95031013pi_cot
picots104616443picots
pieta75421753piet_a
pietas84516503pietas
piety105817303piet_y
pigeon949413pigeon
pigout9314613pi_gout
pigsty1235933pigst_y
pilau73618523pi_lau
pileous9510523pileous
pillow113110573pillow
pilot77435063pi_lot
pilots84018873pilots
pilous84717753pi_lous
pingo87122713pingo_
pingos95317673pingos
pinion83815893pinion
pinitol936683pinitol
pinko115618253pinko_
pinkos125313873pinkos
pinon76024533pi_non
pinot78737293pi_not
pinots85920273pinots
pint66963173pint__
pinta75727053pint_a
pintas85021393pintas
pintle83818263pintle
pintoes95117713pintoes
pints75936223pint_s
pinyon11459763pinyon
pion67235293pi__on
pious74621273pi__ous
pirog83913673pi_rog
pis56362033pis___
piscator1246923piscator
pish96127913pis__h
pished124817063pished
pisher114317753pisher
pishes114722103pishes
pishoge1336693pishoge
pishogue1442833pishogue
piss65033333pis__s
pissed94816933pissed
pisser84416383pisser
pisses84525083pisses
pissoir945043pissoir
pistils93314303pistils
pistoled11259593pistoled
pistoles102514723pistoles
pit56471923pi_t__
pita65436433pi_t_a
pitas77427673pi_tas
pitch125018413pi_tch
piteous9310683piteous
pith95432693pi_t_h
piths105817543pi_ths
pithy135614463pi_thy
pitons85319043pi_tons
pits66348743pi_t_s
pitsaw1135613pitsaw
pitta75018693pi_tta
pittas86014523pittas
pitted94319593pitted
pity96031933pi_t_y
piu56639543pi___u
pivot106523873pi_vot
pivots115111903pivots
pluton838853pluton
poison8312223pois_on
ponton83217643ponton
post67953363post__
postal84317533postal
postbox1885493postbox
postboy1476673postboy
postcoup1443863postcoup
postdoc1245263postdoc
posted93722493posted
poster84129173poster
postie84123963postie
postin83521033postin
postops11311713postops
posts75228783post_s
potto75320943potto_
pottos84615873pottos
poyou102611523p_oyou
presto84216203presto_
prestos93716083prestos
pretor8315753pretor
printout1048123printout
prison8514023pris_on
proton84318893proton
prutot8311823prutot
psst66118403psst__
pst57932513p_st__
punto75121323punto_
puntos85915793puntos
puton73617913p_uton
putout8315113p_utout
putto75617663putto_
riotous739863riotous
ripstop1174763ripstop
ristra6310713ristra
sister64421583sister
sistra639333sistra
sistrum946563sistrum
sou37853693__s_ou
spinto8410663spinto_
spintos939133spintos
stoa45425913__stoa
stob66724613__stob
stop66532033__stop
stot46347333__stot
stoup75517073__stoup
stour54916743__stour
stout57434053__stout
stow77325743__stow
teston6313303teston
tictoc1036003tictoc
tiptoe838283tiptoe
tiptop1036103tiptop
unstop837473unstop
viator93211833viator
victor113210673victor
virtu85314093virt_u
viscous1238833viscous
vision9311313vision
visitor1046203visitor
visor82512833vis_or
vista85416603vist_a
vistas94513273vistas
wisdom1235983wisdom
wist78049293wist__
wisted104120273wisted
wistful1365713wistful
wists86728523wist_s
wittol935923wittol
xystoi16365133xystoi
xystos16356913xystos

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162885.08022188.2
3Display Results2882880.0933096.8
 (SQL Overall)1786912885.54632219.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.