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

393 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
flipper1438914(None) 
clipper133710321clipper
flapper14359201flapper
flipped15358511flipped
flippers15338001flippers
flopper14328471flopper
lipper104219631_lipper
slipper113712981slipper
blipped14377192blipped
chipper163912582chipper
clapper134011862clapper
clipped14439832clipped
clippers14368842clippers
dipper114017792_dipper
dripper12349232dripper
flapped15328252flapped
flappers15388382flappers
flappier1544292flappier
flicker163610622flicker
flier86023402fli__er
flinder11319872flinder
flinger113710512flinger
flippest1535172flippest
flippy1654612flipp_y
flirter10318672flirter
flitter103413902flitter
flivver1633042flivver
flopped15338762flopped
floppers15337462floppers
floppier1554632floppier
flypaper1842222flypaper
frippery1832952frippery
gipper114215302_gipper
gripper124410712gripper
hipper133818022_hipper
kipper143414212_kipper
lapper104319952_lapper
limper104117852_limper
lipped114419542_lipped
lippen103911402_lippen
lippers113416442_lippers
lippier112710572_lippier
lisper84114432_lisper
lopper103717202_lopper
nipper103715712_nipper
quipper2095822quipper
ripper103518652_ripper
shipper143514042shipper
sipper103920992_sipper
skipper15339572skipper
slapper113512462slapper
slipped124711742slipped
slippers123711232slippers
slippery15275862slippery
slippier1256532slippier
snipper113911332snipper
tipper103918412_tipper
tripper113711922tripper
whipper173611382whipper
zipper193813122_zipper
aliener71011193aliener
aligner8108313aligner
aliner65621983ali_ner
aliped95414283ali_ped
bleeper11458253bleeper
blinder103912983blinder
blinker134110213blinker
blister94415313blister
blither124812173blither
blitzer18447663blitzer
blooper11358533blooper
bopper123813833_bopper
caliper11410963cali_per
capper124421983_capper
chipped174110813chipped
chippers173510883chippers
chippier17297673chippier
chirper14359963chirper
chopper163611893chopper
cipher133710263_cipher
clamper134012993clamper
clapped143511173clapped
clappers143310833clappers
clasper113811863clasper
clicker154111883clicker
climber13449133climber
clinger103812153clinger
clinker133811663clinker
clopped143611523clopped
copper124321893_copper
crapper133913193crapper
crimper136510423crimper
crippler14826713crippler
crisper113511053crisper
cropper133312963cropper
crupper13338563crupper
cupper124313863_cupper
dapper114016633_dapper
diaper94513113_diaper
dipped123517493_dipped
dippers123615183_dippers
dippier123111393_dippier
dripped13408083dripped
drippers13327943drippers
drippier1385043drippier
dropper12329873dropper
eclipser1242793eclipser
eloper85414153el_oper
equipper2143053equipper
fainer94717243fai_ner
fainter103611053fainter
fairer95212063fai_rer
feigner1135593feigner
fibber134811933f_ibber
fiber104921133f_i_ber
fifer115519973f_i_fer
filcher15377793filcher
filer85433003f_i_ler
filister1137403filister
filler94623623f_iller
filmer114112403f_ilmer
filmier1237503filmier
filter94517633f_ilter
finder104020233f_inder
finer85431563f_i_ner
finger104920333f_inger
fipple13329063f_ipple
fipples14298653f_ipples
firer811229253f_i_rer
firmer114712443f_irmer
fisher124917143f_isher
fitter94120033f_itter
fiver116024943f_i_ver
fixer154717833f_i_xer
fizzer17369383f_izzer
flagger12469353flagger
flaker134916173fl_aker
flakier143910203flakier
flamer114919123fl_amer
flamier123112143flamier
flanger113412623flanger
flanker143911293flanker
flappy1654483flapp_y
flasher133914063flasher
flatter103815963flatter
flawier13378733flawier
flaxier17337983flaxier
flayer124713563fl_ayer
fleecer12368033fleecer
fleer86020773fl__eer
fleeter103210363fleeter
flenser1036783flenser
flesher133610923flesher
flichter1664963flichter
flicked174610673flicked
flickers17338883flickers
flickery20365103flickery
flied96519433fli__ed
fliers94417193fli__ers
flies85630713fli__es
flimsier1344133flimsier
flincher16256583flincher
flinders12439263flinders
flingers123410193flingers
flinted114411893flinted
flintier1136393flintier
flip96324263fli_p__
flippant1544773flippant
flipping16307663flipping
flips105117743fli_p_s
flir76422203fli___r
flirted11428673flirted
flirters11337933flirters
flirtier1144893flirtier
flite85424963fli_te_
flited104616583fli_ted
flites95122443fli_tes
flitted114011643flitted
flitters114312173flitters
flivvers1733113flivvers
floater104413353floater
flogger12449463flogger
flooder11258463flooder
floorer10248073floorer
flopover1642863flopover
floppies1546813floppies
floppy1654873flopp_y
flosser10339693flosser
flouter104311343flouter
flower124815503fl_ower
flubber14287713flubber
fluffer12336503fluffer
flukier14397853flukier
flumped15377713flumped
flunker14389363flunker
flusher133012273flusher
fluster103913063fluster
fluter95316863fl_uter
flutier103011553flutier
flutter104012093flutter
flyer114916253fl__yer
flyover1633513flyover
flypapers1942033flypapers
flytier13356503flytier
fopped144012673f_opped
foppery17385623f_oppery
frappe13286953frappe_
frapped15318853frapped
frappes14328383frappes
frier85225843fri__er
friller104111743friller
frisker14389273frisker
fritter103912773fritter
frizer184011283fri_zer
frizzer18446893frizzer
gipped124815903_gipped
gippers123212083_gippers
glibber1235163glibber
glider84614263gli_der
glimmer12437713glimmer
glimpser1342663glimpser
glister84013343glister
glitter84211803glitter
glopped13347613glopped
gloppier1354673gloppier
griper94114613gri_per
gripier103210323gripier
grippe115310323grippe_
gripped13419343gripped
grippers13358133grippers
grippes124810373grippes
grippier1355203grippier
gypper14347293_gypper
hepper133412663_hepper
hipped144317693_hipped
hippier143212103_hippier
hopper134218483_hopper
jimper17389863_jimper
kipped153114573_kipped
kippen14299013_kippen
kippers153211433_kippers
klister113410643klister
knapper15387153knapper
lapped114320033_lapped
lappers113717463_lappers
lappet103817723_lappet
lapser84113143_lapser
leaper88118943_leaper
leper74820743_l_eper
libber104414013_libber
liber74723623_li_ber
licker125222043_licker
lieder74912323_lieder
liefer9529573_liefer
lier45942463_li__er
liever94611863_liever
lifer85822153_li_fer
lifter93814813_lifter
liger65024473_li_ger
liker95627063_li_ker
limber104316793_limber
limier83518723_limier
limmer104314793_limmer
limner84112873_limner
limped114817123_limped
limpers113815223_limpers
limpet103518633_limpet
liner55938923_li_ner
linger75226003_linger
linier64423793_linier
linker104321473_linker
linter64625343_linter
lipe66839733_li_pe_
lippens11328533_lippens
lippered13287953_lippered
lippy124511903_lipp_y
lisped94113423_lisped
lispers94514323_lispers
lister64527253_lister
liter54736343_li_ter
lither94520953_lither
litter64324853_litter
liver85132963_li_ver
livier97514593_livier
livyer12426293_livyer
looper83817113_looper
loper75129233_l_oper
lopped114218623_lopped
loppers113014103_loppers
loppier11369723_loppier
lumper103816653_lumper
mapper124516093_mapper
mopper126215003_mopper
napper103718283_napper
nipped113615853_nipped
nippers113012623_nippers
nippier11319833_nippier
oilpaper1242853oilpaper
pepper93512943_pepper
piper96523193_pi_per
pipier104913983_pipier
pipped104516543_pipped
plier75221283pli__er
plinker134010963plinker
plopped11288773plopped
plumper13318773plumper
popper93615963_popper
quipped2175163quipped
quippers2184813quippers
quippier2133773quippier
rapper104621573_rapper
riper74328403_ri_per
ripped114419013_ripped
rippers114115033_rippers
rippler113210103_rippler
sapper103822353_sapper
scupper1367423scupper
shipped153312103shipped
shippen14298863shippen
shippers153012313shippers
shopper143312633shopper
simper103616293_simper
sipped113720633_sipped
sippers113117753_sippers
sippet103519393_sippet
skipped16358413skipped
skippers16318203skippers
skippet15288463skippet
slapped123511843slapped
slappers123710943slappers
sleeper93211563sleeper
slicer84117603sli_cer
slicker133314533slicker
slider73918363sli_der
slier54827243sli__er
slimier93212013slimier
slimmer114211343slimmer
slinger83413833slinger
slipe75626133sli_pe_
sliped95417063sli_ped
slipes84921413sli_pes
slipover1343833slipover
slippered1434823slippered
slippy1375843slipp_y
slither104112983slither
slitter73615873slitter
sliver94116593sli_ver
sloper84615913sl_oper
slopped123511443slopped
sloppier1255703sloppier
snapper113512073snapper
sniper84413643sni_per
snipped123510043snipped
snippers12299723snippers
snippet113310433snippet
snippier1255793snippier
stepper113010853stepper
stippler1235543stippler
stopper113012603stopper
stripper1247123stripper
supper104115433_supper
swapper14359703swapper
tapper104419613_tapper
tipped114418263_tipped
tippers113414353_tippers
tippet103917873_tippet
tippier113210543_tippier
tippler11348343_tippler
topper103817603_topper
trapper113912803trapper
tripped123911693tripped
trippers123210163trippers
trippet113714113trippet
trippier1246623trippier
upper93714263__upper
viper105017303_vi_per
whapper17348273whapper
whimper17297723whimper
whipped18379333whipped
whippers18329043whippers
whippet17328843whippet
whippier18265823whippier
whisper15298013whisper
whopper17328503whopper
wiper105421293_wi_per
wrapper14368333wrapper
yapper133714513_yapper
yipped143613283_yipped
yippee132810743_yippee
zapper193414023_zapper
zipped203612983_zipped
zippers203310383_zippers
zippier20308193_zippier

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.1561145455.1
2DLD Change Limit1340273937.32618294.7
3Display Results3933930.1432748.3
 (SQL Overall)1786913937.62523434.9
 
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.