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

278 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
flappy165448(None) 
flippy1654611flippy
floppy1654871floppy
crappy15446802crappy
flabby1634572flabby
flaggy14415922flaggy
flakey164410512flakey
flaky155715582fla_ky
flamy135217472fla_my
flap96128702fla_p_
flapped15328252flapped
flapper14359202flapper
flaps105621382fla_ps
flashy15498172flashy
flatly123110212flatly
flawy145913382fla_wy
flaxy189012292fla_xy
flay106332802fla__y
frappe13286952frappe
gappy136212032_gappy
gloppy1454722gloppy
happy155813532_happy
lippy124511902_lippy
loppy125911662_loppy
nappy126312332_nappy
pappy114713802_pappy
sappy125413472_sappy
slippy1375842slippy
sloppy1395302sloppy
snappy1366102snappy
zappy21548942_zappy
alary86123443ala_ry
app76827603__app_
apply125111393__apply
apps86319693__apps
blabby1234813blabby
blasty115611053blasty
buppy144810073_buppy
campy145116183_campy
champy18509613champy
chippy18437613chippy
choppy18376293choppy
clammy15356333clammy
clamp115517653clamp_
clamps124515083clamps
clanky15469073clanky
clap86429043cla_p_
clapped143511173clapped
clapper134011863clapper
claps95626183cla_ps
clapt98027173cla_pt
clary105719613cla_ry
clasp95517193clasp_
clasps104512093clasps
claspt104513413claspt
classy11379043classy
clay95927413cla__y
clayey14407663clayey
clumpy15409573clumpy
crampy154710993crampy
cuppy144710383_cuppy
dippy135111543_dippy
drapey125010583drapey
drippy14445653drippy
elapid939543elapid
elapse857523elapse
faddy135511623f_addy
faery116015483f_aery
faggy136514373f_aggy
fairy115318283f_airy
fakey155515423f_akey
fancy134615483f_ancy
fanny114816043f_anny
farcy135217093f_arcy
fatly115716803f_atly
fatty115117413f_atty
fawny144711713f_awny
fay97454863f_a__y
fealty122910223fealty
featly123711753featly
flab96628353fla__b
flabs105818643fla_bs
flack144519413fla_ck
flacks154114533flacks
flacon1138633flacon
flag87427083fla__g
flagon1037983flagon
flags95321283fla_gs
flail85316183fla_il
flails94313003flails
flair86114123fla_ir
flairs95711913flairs
flak116026173fla__k
flake125119973fla_ke
flaked144715653flaked
flaker134916173flaker
flakes134118873flakes
flakily1736293flakily
flam96333293fla__m
flambe13489153flambe
flame105124443fla_me
flamed124618973flamed
flamen115215993flamen
flamer114919123flamer
flames114723693flames
flams105125013fla_ms
flan76134183fla__n
flanes94522423flanes
flange103411973flange
flank124618093fla_nk
flanks133913403flanks
flans85327973fla_ns
flappers15388383flappers
flappier1544293flappier
flapping16298153flapping
flare84823633fla_re
flared105317603flared
flares94521703flares
flash115716213fla_sh
flask125512423fla_sk
flasks13488673flasks
flat77147823fla__t
flats86429743fla_ts
flatus94310783flatus
flaunt9712913flaunt
flaunty1354413flaunty
flauta937823flauta
flavin1239303flavin
flavor1236663flavor
flavory1644743flavory
flaw106326643fla__w
flawed134712723flawed
flaws115920343fla_ws
flax147325633fla__x
flaxen16518573flaxen
flaxes165015353flaxes
flayed134414053flayed
flayer124713563flayer
flays116321053fla_ys
fleapit1255993fleapit
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleshy15406283fleshy
fleury12417353fleury
fley106626853fl__ey
flimsy14345563flimsy
flinty126112493flinty
flip96324263fl_ip_
flipped15358513flipped
flipper14389143flipper
flips105117743fl_ips
flirty12499143flirty
floaty124210943floaty
flocky18468423flocky
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
flop96925453fl_op_
flopped15338763flopped
flopper14328473flopper
floppily1843773floppily
flops105920143fl_ops
flossy12517703flossy
floury12449573floury
fluffy14315783fluffy
flukey16459813flukey
fluky154512293fl_uky
flump124614723flump_
flumps135112503flumps
flunky16408093flunky
flurry12397113flurry
flutey125212523flutey
fluty114415643fl_uty
fly97124953fl___y
flyaway1943163flyaway
flyboy17113913flyboy
flyby1676003fl_yby
flyway18134693flyway
foamy135313203foa_my
frap95925813fra_p_
frapped15318853frapped
frappes14328383frappes
fraps105620553fra_ps
fray105428903fra__y
frumpy16466883frumpy
gapy106320913_ga_py
gladly11497933gladly
glady105413943gla_dy
glairy10448273glairy
glary96018543gla_ry
glassy10527753glassy
glazy187410983gla_zy
glumpy14527193glumpy
grapey126012303grapey
grappa11396443grappa
grapy115416433gra_py
grippy14447763grippy
guppy135211273_guppy
haply135915063_haply
harpy136418213_harpy
heapy135914983hea_py
hippy155112793_hippy
hoppy154912353_hoppy
jaloppy21302483jaloppy
jalopy18325863jalopy
kappa13469743_kappa
lacey105820913_lacey
lacy95829633_la_cy
lady86527153_la_dy
laity85318903_laity
laky116725823_la_ky
lamby125114843_lamby
lamp86233823_lamp_
lamps95624833_lamps
lanky125517483_lanky
lap58565273_la_p_
lapel73716683_lapel
lapin75222923_lapin
lapis76223153_lapis
lapped114320033_lapped
lapper104319953_lapper
lappet103817723_lappet
laps66848873_la_ps
lapse74917683_lapse
lardy96119273_lardy
larky125218873_larky
lathy115215063_lathy
lawny115912013_lawny
laxly15610103_laxly
lay68865353_la__y
lazy166423073_la_zy
loopy105316643_loopy
lumpy126615913_lumpy
nappa98511863_nappa
nappe96114993_nappe
nippy124911113_nippy
pappi84810893_pappi
peppy114310363_peppy
plaguy12386413plaguy
plashy14448873plashy
platy105021663pla_ty
play95928983pla__y
poppy114813193_poppy
preppy1235523preppy
puppy114912413_puppy
quippy22384263quippy
raspy106511703_raspy
reapply1434323reapply
scrappy16234473scrappy
sharpy145211033sharpy
slaggy11438793slaggy
slangy105411393slangy
slanty95114843slanty
slap66434043sla_p_
slapped123511843slapped
slapper113512463slapper
slaps76025713sla_ps
slatey95417063slatey
slaty86523153sla_ty
slavey124011803slavey
slay76436383sla__y
sleepy11479413sleepy
snippy1374843snippy
soapy106114783soa_py
soppy125113523_soppy
strappy14205263strappy
swampy16437233swampy
teapoy1138113teapoy
tippy125411793_tippy
trampy13499253trampy
trippy13457803trippy
unhappy1742803unhappy
vampy15539403_vampy
waspy135410993_waspy
whippy19385843whippy
yuppy15487913_yuppy
zippy21518743_zippy

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.390458182.1
2DLD Change Limit1127162785.11022057.9
3Display Results2782780.0803475.0
 (SQL Overall)1786912785.58032023.5
 
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.