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

236 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
flippy165461(None) 
flappy1654481flappy
floppy1654871floppy
lippy124511901_lippy
slippy1375841slippy
chippy18437612chippy
dippy135111542_dippy
drippy14445652drippy
flimsy14345562flimsy
flinty126112492flinty
flip96324262fli_p_
flipped15358512flipped
flipper14389142flipper
flips105117742fli_ps
flirty12499142flirty
gloppy1454722gloppy
grippy14447762grippy
hippy155112792_hippy
loppy125911662_loppy
nippy124911112_nippy
quippy22384262quippy
sloppy1395302sloppy
snippy1374842snippy
tippy125411792_tippy
trippy13457802trippy
whippy19385842whippy
zippy21518742_zippy
aliped95414283aliped
blimey13468453blimey
blimp115612943blimp_
blimps12588153blimps
blimy125212823bli_my
blip88322773bli_p_
blipped14377193blipped
blips95615783bli_ps
buppy144810073_buppy
chirpy16498913chirpy
choppy18376293choppy
cliffy17435243cliffy
clingy12659063clingy
clip86924003cli_p_
clipped14439833clipped
clipper133710323clipper
clips96018303cli_ps
clipt96324273cli_pt
cliquy20324713cliquy
clumpy15409573clumpy
crappy15446803crappy
crimpy15489393crimpy
crispy13478563crispy
cuppy144710383_cuppy
fairly125610013fairly
fairy115318283fai_ry
feisty12449293feisty
fiery114714793f_iery
fifty145211423f_ifty
filly114424903f_illy
filmy136114043f_ilmy
filthy15356423filthy
finny114716753f_inny
fipple13329063f_ipple
firry115713533f_irry
fishy146011663f_ishy
fitly115114973f_itly
fizzy199015083f_izzy
flabby1634573flabby
flaggy14415923flaggy
flakey164410513flakey
flaky155715583fl_aky
flamy135217473fl_amy
flap96128703fl_ap_
flapped15328253flapped
flapper14359203flapper
flaps105621383fl_aps
flashy15498173flashy
flatly123110213flatly
flawy145913383fl_awy
flaxy189012293fl_axy
flay106332803fl__ay
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleshy15406283fleshy
fleury12417353fleury
fley106626853fl__ey
flic96223733fli__c
flick145017213fli_ck
flicks154512993flicks
flics105418363fli_cs
flied96519433fli_ed
flier86023403fli_er
fliers94417193fliers
flies85630713fli_es
fliest94718433fliest
flight134014813flight
flighty17347433flighty
flinch144010103flinch
fling97023513fli_ng
flings106715283flings
flint87333503fli_nt
flints95617453flints
flippancy2151693flippancy
flippant1544773flippant
flippers15338003flippers
flippest1535183flippest
flipping16307663flipping
flir76422203fli__r
flirs85518933fli_rs
flirt87424753fli_rt
flirts95411483flirts
flit76539273fli__t
flitch14928173flitch
flite85424963fli_te
flited104616583flited
flites95122443flites
flits85625223fli_ts
floaty124210943floaty
flocky18468423flocky
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
flop96925453fl_op_
flopped15338763flopped
flopper14328473flopper
floppily1843773floppily
flops105920143fl_ops
flossy12517703flossy
floury12449573floury
fluffy14315783fluffy
fluidly1434813fluidly
flukey16459813flukey
fluky154512293fl_uky
flump124614723flump_
flumps135112503flumps
flunky16408093flunky
flurry12397113flurry
flutey125212523flutey
fluty114415643fl_uty
fly97124953fl___y
flyboy17113913flyboy
flyby1676003fl_yby
flyway18134693flyway
frappe13286953frappe
friary124010093friary
frilly124111443frilly
fringy13309263fringy
frippery1832953frippery
frisky16406673frisky
frizzy20555833frizzy
frumpy16466883frumpy
gappy136212033_gappy
gimpy135212233_gimpy
gipsy11579543_gipsy
glibly1236293glibly
glinty106910693glinty
glitzy19404783glitzy
glumpy14527193glumpy
gripey124111203gripey
grippe115310323grippe
gripy115115253gri_py
guppy135211273_guppy
happy155813533_happy
hiply134113613_hiply
hippo12369063_hippo
hoppy154912353_hoppy
jaloppy21302483jaloppy
jimpy195210823_jimpy
lily76730193_li_ly
limby125714073_limby
limey104721043_limey
limp88432503_limp_
limpa97014463_limpa
limply133810033_limply
limps95522673_limps
limpsy13516843_limpsy
limy95727723_li_my
lindy96918323_lindy
liney87029633_liney
lingy96925143_lingy
linky127622383_linky
linty87126563_linty
liny78141333_li_ny
lip514755813_li_p_
lipa68425933_li_pa
lipe66839743_li_pe
lipid85916173_lipid
lipin75518893_lipin
lipped114419543_lipped
lippen103911403_lippen
lipper104219633_lipper
lips67141453_li_ps
lisp68926893_lisp_
lisps76913913_lisps
loopy105316643_loopy
lumpy126615913_lumpy
nappy126312333_nappy
pappy114713803_pappy
peppy114310363_peppy
pipy115421523_pi_py
plisky1533713plisky
poppy114813193_poppy
preppy1235523preppy
puppy114912413_puppy
quippu19344863quippu
ripply13348003_ripply
sappy125413473_sappy
skimpy17475723skimpy
sleepy11479413sleepy
slily85820033sli_ly
slimly11408903slimly
slimpsy1463333slimpsy
slimsy11407723slimsy
slimy105417423sli_my
slinky13399103slinky
slip67031733sli_p_
slipe75626133sli_pe
sliped95417063sliped
slipes84921413slipes
slipped124711743slipped
slipper113712983slipper
slippery15275863slippery
slippily1544193slippily
slips76023723sli_ps
slipt76627483sli_pt
slipup1034503slipup
slipups1133193slipups
slipway1543873slipway
slitty9329163slitty
snappy1366103snappy
soppy125113523_soppy
tipsy106010503_tipsy
triply114211023triply
wimpy155911923_wimpy
wispy137210973_wispy
yuppy15487913_yuppy
zappy21548943_zappy

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.376475242.0
2DLD Change Limit1127162365.40620850.2
3Display Results2362360.0763105.3
 (SQL Overall)1786912365.85830503.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.