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

214 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
piaffe149491(None) 
piaffed1693751piaffed
piaffer15104441piaffer
piaffes15115051piaffes
gaffe124111652_gaffe
giraffe1442992giraffe
piaffers16114202piaffers
piazze1634682piazze
piffle14418232piffle
pilaff143910362pilaff_
pilaffs15365152pilaffs
pouffe14448262pouffe
aff95537613__aff_
agraffe1443333agraffe
baff124632273_baff_
baffed154812173_baffed
baffle14399873_baffle
baffs134718053_baffs
baffy165511923_baffy
biface1358103biface
biff125026893bi_ff_
biffed15449883bi_ffed
biffs134814413bi_ffs
biffy164711133bi_ffy
blaff135216483blaff_
blaffs14426623blaffs
bouffe14438313bouffe
cafe95230323_ca_fe
caff125631673_caff_
caffs135417373_caffs
chafe135117353cha_fe
chaff165016283chaff_
chaffed19387703chaffed
chaffer18389473chaffer
chaffs17459613chaffs
chaffy20456473chaffy
coiffe1447043coiffe
daff115229683_daff_
daffed14429493_daffed
daffs125116423_daffs
daffy155510283_daffy
diff116228843di_ff_
differ133910843di_ffer
diffs126315483di_ffs
draff125615663draff_
draffs13617903draffs
draffy16486633draffy
fiacre1137623fiacre
fiance11310743fiance
fife106027703fi__fe
gaff114828153_gaff_
gaffed144210203_gaffed
gaffer134310133_gaffer
gaffes134811103_gaffes
gaffs124914653_gaffs
giraffes1542603giraffes
griffe13438093griffe
haffet15311703_haffet
iff96730393_i_ff_
iffy135312283_i_ffy
jiff175321413ji_ff_
jiffs185710313ji_ffs
jiffy21458313ji_ffy
liable81415813liable
liaise6310693liaise
liane54720663lia_ne
life75433733li__fe
miff125625063mi_ff_
miffed15398713mi_ffed
miffs134512883mi_ffs
miffy163910203mi_ffy
naff105128933_naff_
naffed13408333_naffed
naffs116213963_naffs
niffer12378443ni_ffer
opiate8513463opia_te
pace86345773p_a_ce
padle84522343p_adle
padre86018163p_adre
page76036103p_a_ge
paise75028333p_aise
pale66055013p_a_le
pane64950283p_a_ne
panne76623653p_anne
parae76335703p_arae
pare66760843p_a_re
parge85831853p_arge
parle75836163p_arle
parse75236993p_arse
parve109824853p_arve
pase65346863p_a_se
passe75525693p_asse
paste74932953p_aste
pate65350463p_a_te
pause75021833p_ause
pave96133893p_a_ve
payee105524723p_ayee
peace95026083pea_ce
peage84723563pea_ge
pease75231113pea_se
pfft12311883p__fft
phage115113673pha_ge
phase104617213pha_se
pia56848033pia___
piaffing1733923piaffing
pial65636703pia__l
pian66136093pia__n
pianic103714123pianic
piano76118713pia_no
pianos84315933pianos
pians75126963pia_ns
pias66542553pia__s
piaster93012883piaster
piastre9307893piastre
piazza1643823piazza
picante11310523picante
pice84641093pi__ce
pickle144215653pickle
piddle103514913piddle
pie55457403pi___e
piece96717993pi_ece
pierce104010393pierce
piffled16366403piffled
piffles15368763piffles
piggie103210773piggie
pikake11115803pikake
pike106335213pi__ke
pilaf103923483pilaf_
pilafs113511023pilafs
pile65649693pi__le
pilfer1139163pilfer
pilose84514243pilose
pilule8411123pilule
pimple123512963pimple
pinafore1344513pinafore
pine67755713pi__ne
pinene82915643pinene
pinite8321243pinite
pinkie124414273pinkie
pinnae84414643pinnae
pinole83218783pinole
pintle83818263pintle
pipage1199143pipage
pipe86434433pi__pe
pique16410173pi_que
pirate82322883pirate
piste75824603pi_ste
pixie145415523pi_xie
pizzle16279493pizzle
place94824613pla_ce
plage84520403pla_ge
plague93610853plague
plaice10311553plaice
plane74929143pla_ne
plaque17317643plaque
plate74635113pla_te
pliable111610323pliable
pouff135215423pouff_
pouffed16365953pouffed
pouffes15408123pouffes
pouffs14418123pouffs
pouffy17395883pouffy
praise84419413praise
prance104318573prance
prase76128753pra_se
prate75135983pra_te
proffer15126933proffer
puff125525433p_uff_
puffed153510603p_uffed
puffer144610733p_uffer
puffs134114933p_uffs
puffy164410753p_uffy
purfle112511183purfle
quaff201311353quaff_
quaffed2334253quaffed
quaffer2235133quaffer
quaffs21125693quaffs
raff104933043_raff_
raffle123910703_raffle
raffs115017523_raffs
rife74632323ri__fe
riff104430103ri_ff_
riffed133811563ri_ffed
riffle124210233riffle
riffs115114613ri_ffs
rifle85518333ri_fle
ruffe114713813_ruffe
safe75930953_sa_fe
snaffle13216243snaffle
spiff133616403spi_ff_
spiffed16257103spi_ffed
spiffs14328473spi_ffs
spiffy17326223spi_ffy
staff113817713staff_
staffed14298283staffed
staffer13299093staffer
staffs12349753staffs
taffy145110823_taffy
tiff104727723ti_ff_
tiffed13368393ti_ffed
tiffs114414883ti_ffs
truffe1276233truffe
viable111613773viable
waff134228043_waff_
waffed16459793_waffed
waffie15338563_waffie
waffle15369183_waffle
waffs146315473_waffs
wife105228023wi__fe
yaff135324263_yaff_
yaffed16457323_yaffed
yaffs145311123_yaffs
zaffer21397153_zaffer
zaffre21354663_zaffre

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127162147.81314426.7
3Display Results2142140.0603566.7
 (SQL Overall)1786912148.04622208.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.