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

188 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
flappier154429(None) 
flapper14359201flapp_er
floppier1554631floppier
clapper134011862clapp_er
crappier14288132crappier
flabbier1534092flabbier
flaggier13105202flaggier
flakier143910202fla_kier
flamier123112142fla_mier
flapped15328252flapp_ed
flappers15388382flapp_ers
flappiest1644852flappiest
flapping16298152flapping
flashier1437102flashier
flawier13378732fla_wier
flaxier17337982fla_xier
flipper14389142flipp_er
flopper14328472flopp_er
floppies1546812floppies
gappier12369842_gappier
gloppier1354672gloppier
happier143312032_happier
lapper104319952_lapp_er
lippier112710572_lippier
loppier11369722_loppier
nappier114411172_nappier
pappier103511592_pappier
sappier113613112_sappier
slapper113512462slapp_er
slippier1256532slippier
sloppier1255702sloppier
snappier1266212snappier
zappier20458372_zappier
applier1137903__applier
blastier10249493blastier
campier133313273_campier
capper124421983_capp_er
chappie16298653chappie_
chappies172610093chappies
chippier17297673chippier
choppier17286643choppier
clammier1435843clammier
clamper134012993clamp_er
clankier14327083clankier
clapped143511173clapp_ed
clappers143310833clapp_ers
clapping153810603clapping
clasper113811863clasp_er
classier10359083classier
clavier1239173cla_vier
clayier1248323cla_yier
clipper133710323clipp_er
clumpier1435583clumpier
crampier14288903crampier
crapper133913193crapp_er
crappie13298983crappie_
crappies142911153crappies
cuppier1368323_cuppier
dapper114016633_dapp_er
dippier123111393_dippier
drippier1385043drippier
faddier1237783f_addier
faggier12309843f_aggier
fancier123412063f_ancier
farrier103514893f_arrier
fattier103513463f_attier
fawnier13296363f_awnier
featlier1136453featlier
flagger12469353fla_gger
flair86114123fla__i_r
flaker134916173fla__ker
flamer114919123fla__mer
flanger113412623fla_nger
flanker143911293fla_nker
flappy1654483flapp__y
flasher133914063fla_sher
flatliner12285383flatliner
flatter103815963fla_tter
flaunter1135013flaunter
flauntier1243063flauntier
flavorer1454553flavorer
flayer124713563fla__yer
fledgier1333683fledgier
fleecier1334763fleecier
fleshier1435603fleshier
flier86023403fl___ier
flimsier1344133flimsier
flintier1136393flintier
flipped15358513flipp_ed
flippers15338003flipp_ers
flipping16307663flipping
flirtier1144893flirtier
floatier1136983floatier
flockier1745343flockier
flopover1642863flopover
flopped15338763flopp_ed
floppers15337463flopp_ers
floppiest1654773floppiest
floppily1843773floppily
flopping16388773flopping
flossier11326973flossier
fluffier13264333fluffier
flukier14397853fl_ukier
flutier103011553fl_utier
flypaper1842223flypaper
flytier13356503fl_ytier
foamier12339003foa_mier
frappe13286953frapp_e_
frapped15318853frapp_ed
frappes14328383frapp_es
frapping16348103frapping
frumpier1534173frumpier
glacier103911293gla_cier
gladier93810993gla_dier
gladlier1034343gladlier
glairier944833glairier
glarier84112203gla_rier
glassier9289083glassier
glazier17409353gla_zier
glumpier1334873glumpier
grapier103712603gra_pier
grappler13336193grappler
grippier1355203grippier
hippier143212103_hippier
hoppier143110703_hoppier
knapper15387153knapp_er
lacier84020093_la_cier
lakier104716273_la_kier
lambier113611643_lambier
lankier113711633_lankier
lapped114320033_lapp_ed
lappers113717463_lapp_ers
lappet103817723_lapp_et
lapping124117023_lapping
lapser84113143_la_pser
lardier83518343_lardier
larkier113711523_larkier
lathier10310833_lathier
lazier154214613_la_zier
lipper104219633_lipp_er
loopier93711193_loopier
lopper103717203_lopp_er
lumpier113410143_lumpier
mapper124516093_mapp_er
napper103718283_napp_er
nappie104112263_nappie_
nappies114613393_nappies
nippier11319833_nippier
pappies103214823_pappies
peppier10268323_peppier
plashier1337613plashier
platier93716293pla_tier
preppier1156643preppier
quippier2133773quippier
rapier84019993_ra_pier
rapper104621573_rapp_er
raspier93110643_raspier
sapper103822353_sapp_er
scrappier1544423scrappier
slaggier10126953slaggier
slangier9117933slangier
slapped123511843slapp_ed
slappers123710943slapp_ers
slapping133510833slapping
slatier74016813sla_tier
sleepier1036783sleepier
slipper113712983slipp_er
snapper113512073snapp_er
snippier1255793snippier
soapier93411713soa_pier
soppier112711583_soppier
strappier1345133strappier
swampier1544593swampier
swapper14359703swapp_er
tapper104419613_tapp_er
tippier113210543_tippier
trampier12318243trampier
trapper113912803trapp_er
trippier1246623trippier
unhappier1642393unhappier
vampier14308233_vampier
waspier12259053_waspier
whapper17348273whapp_er
whippier18265823whippier
wrapper14368333wrapp_er
yapper133714513_yapp_er
zapper193414023_zapp_er
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 Filter1786911461620.403443402.0
2DLD Change Limit1461621887.00320871.3
3Display Results1881880.0762473.7
 (SQL Overall)1786911887.48223882.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.