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 “piaffes” 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
piaffes1511505(None) 
piaffe1494911piaffe_
piaffed1693751piaffed
piaffer15104441piaffer
piaffers16114201piaffers
gaffes134811102_gaffes
giraffes1542602giraffes
piffles15368762piffles
pilaffs15365152pilaff_s
pouffes15408122pouffes
agraffes1553043agraffes
apiaries10312733apiaries
baffed154812173_baffed
baffies153612943_baffies
baffles153710683_baffles
baffs134718053_baff_s
bialies93618413bialies
biases84618433bia_ses
biasses94911653biasses
bifaces1448063bifaces
biffed15449883bi_ffed
biffies152710853biffies
biffs134814413bi_ff_s
blaffs14426623blaff_s
bouffes15388633bouffes
cafes106426923_ca_fes
caffs135417373_caff_s
chafes145017913cha_fes
chaffed19387703chaffed
chaffer18389473chaffer
chaffers19378003chaffers
chaffs17459613chaff_s
coiffes1546803coiffes
daffed14429493_daffed
daffs125116423_daff_s
diaries83321953diaries
differ133910843di_ffer
differs14339973di_ffers
diffs126315493di_ff_s
draffs13617903draff_s
fiacres1237253fiacres
fiances12310673fiances
fifes114822393fi__fes
gaffe124111653_gaffe_
gaffed144210203_gaffed
gaffer134310133_gaffer
gaffers14428713_gaffers
gaffs124914653_gaff_s
giraffe1442993giraffe_
griffes14367923griffes
haffet15311703_haffet
haffets1636053_haffets
jiffies20327473jiffies
jiffs185710313ji_ff_s
liaises7311053liaises
lianes63819323lia_nes
miffed15398713mi_ffed
miffs134512883mi_ff_s
naffed13408333_naffed
naffs116213963_naff_s
niffer12378443ni_ffer
niffers13287363ni_ffers
opiates9312143opia_tes
paces96741113p_a_ces
padles95221123p_adles
padres95016983p_adres
pages85235073p_a_ges
pales75753803p_a_les
panes76148693p_a_nes
pannes85522853p_annes
pares77164483p_a_res
parges94529543p_arges
paries84742513p_aries
parles86334403p_arles
parses85534703p_arses
pases75346503p_a_ses
pashes115828393p_ashes
passes86030473p_asses
pastes85233913p_astes
pates76047893p_a_tes
pauses84621473p_auses
paves104833923p_a_ves
paxes144928423p_a_xes
payees114812903p_ayees
peaces106324083pea_ces
peaches144120053peaches
peages94321853pea_ges
peases85229473pea_ses
peavies122213403peavies
phages125213513pha_ges
phases114618403pha_ses
piaffing1733923piaffing
pianos84315933pia_nos
pians75126963pia__ns
pias66542553pia___s
piaster93012883piaster
piasters102912813piasters
piastres10249303piastres
piazzas1743643piazzas
piazze1634683piazze_
pickles153215443pickles
piddles114314273piddles
pieces104217273pi_eces
pierces113411193pierces
pies66949603pi___es
pieties9419223pieties
piffle14418233pi_ffle
piffled16366403piffled
piggies113813483piggies
pigmies122610993pigmies
pikakes1245823pikakes
pikes115031033pi__kes
pilaff143910363pilaff__
pilafs113511023pilaf_s
piles74742613pi__les
pilfer1139163pi_lfer
pilfers1238963pilfers
pilules9510623pilules
pimples133012423pimples
pinafores1444503pinafores
pinches144117933pinches
pinenes93416683pinenes
pines76048863pi__nes
pingoes105116523pingoes
pinites9319533pinites
pinkies133818263pinkies
pinkoes135512313pinkoes
pinnies93318443pinnies
pinoles93418703pinoles
pinones94717073pinones
pintles94118723pintles
pintoes95117713pintoes
pipages1289423pipages
pipes96030143pi__pes
piques1739093pi_ques
piracies12312643piracies
pirates93020333pirates
pishes114722103pi_shes
pisses84525083pi_sses
pistes85325633pi_stes
pitches143617753pitches
pities83828083pi_ties
pixes144323173pi__xes
pixies154915513pi_xies
pizazzes1742373pizazzes
pizzles17329273pizzles
places104323703pla_ces
plages94520153pla_ges
plagues103311063plagues
plaices11411143plaices
planes85028083pla_nes
plaques18317893plaques
plashes124417393plashes
plates85432243pla_tes
platies93722543platies
poaches144416943poaches
pouffe14448263pouffe_
pouffed16365953pouffed
pouffs14418123pouff_s
praises94121103praises
prances113618773prances
prases84429023pra_ses
prates84633163pra_tes
praxes156215183pra_xes
proffer15126933proffer
proffers16126593proffers
puffed153510603p_uffed
puffer144610733p_uffer
puffers15349203p_uffers
puffs134114933p_uff_s
purfles122511843purfles
quaffed2334253quaffed
quaffer2235133quaffer
quaffers2333963quaffers
quaffs21125693quaff_s
raffles133611843_raffles
raffs115017523_raff_s
riffed133811563ri_ffed
riffles133911163riffles
riffs115114613ri_ff_s
rifles94217703ri_fles
ruffes124112423_ruffes
safes85226723_sa_fes
snaffles14246043snaffles
spiffed16257103spi_ffed
spiffies16277993spiffies
spiffs14328473spi_ff_s
staffed14298283staffed
staffer13299093staffer
staffers14247083staffers
staffs12349753staff_s
taffies133012693_taffies
tiffed13368393ti_ffed
tiffs114414883ti_ff_s
truffes1356773truffes
waffed16459793_waffed
waffies163611443_waffies
waffles16329983_waffles
waffs146315473_waff_s
wifes114522563wi__fes
yaffed16457323_yaffed
yaffs145311123_yaff_s
zaffer21397153_zaffer
zaffers22386773_zaffers
zaffres22324993_zaffres

Search took 8 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.406440125.6
2DLD Change Limit1340272057.09318895.7
3Display Results2052050.0802562.5
 (SQL Overall)1786912057.57923577.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.