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

170 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
slipup103450(None) 
slipups1133191slipups
sirup74014912s_irup
situp74414062s_itup
slip67031732sli__p
slipe75626132slip_e
sliped95417062sliped
slipes84921412slipes
slipout949082slipout
slippy1375842slippy
slips76023722slip_s
slipt76627482slip_t
aliped95414283aliped
blimp115612943bli_mp
blip88322773bli__p
blips95615783blip_s
blowup1335063blowup
clip86924003cli__p
clips96018303clip_s
clipt96324273clip_t
clique17289193clique
cliquy20324713cliquy
flip96324263fli__p
flippy1654613flippy
flips105117743flip_s
ilium74614183ili_um
layup1037723_layup
letup73712163_letup
lieu46534363_lieu_
lieus56218483_lieus
limp88432493_li_mp
lineup835983_lineup
linkup1245123_linkup
linum7313823_linum
lip514755803_li__p
lipa68425923_lip_a
lipe66839733_lip_e
lipid85916173_lipid
lipin75518893_lipin
lippy124511903_lippy
lips67141443_lip_s
lisp68926873_li_sp
litu47631563_litu_
loup66028433_l_oup
lupus74512523_lupus
mixup1636773_mixup
oilcup1044253oilcup
pileup10437923pileup
pinup9612883_pinup
pup76339883___pup
quippu19344863quippu
quipu164811643quipu_
quipus17458003quipus
sannup836563sannup
scaup95515993s_caup
scup84822383s__cup
sendup9106343sendup
setup73915823s_etup
shapeup1443293shapeup
ship95228233shi__p
shiplap1444513shiplap
ships105123773ship_s
shlepp13366193shlep_p
sieur5911893s_ieur
siliqua1643983siliqua
silique1645643silique
simp85228773s_i_mp
sinus55523853s_inus
sip57656013s_i__p
sipe67341043s_ip_e
siped84927683s_iped
sipes76036953s_ipes
sips65740103s_ip_s
sirups83710533s_irups
sirupy11377053s_irupy
situps8538783s_itups
situs55019233s_itus
skimp135411313ski_mp
skip105421743ski__p
skips115616603skip_s
slap66434043sl__ap
slaps76025713slap_s
sleep74920183sl_eep
slept75728103slep_t
slice74925823sli_ce
sliced94416313sliced
slicer84117603slicer
slices84022853slices
slick115520523sli_ck
slicks124816113slicks
slid55828983sli__d
slide64725413sli_de
slider73918363slider
slides73922183slides
slier54827243sli_er
sliest66621943sliest
slieve9359273slieve
slight103416003slight
slily85820033sli_ly
slim66631953sli__m
slime74925753sli_me
slimed94915123slimed
slimes84722043slimes
slimly11408903slimly
slimpsy1463333slimpsy
slims75423653sli_ms
slimsy11407723slimsy
slimy105417423sli_my
sling66028803sli_ng
slings74618013slings
slink95422913sli_nk
slinks104315153slinks
slinky13399103slinky
sliping103314413sliping
slipouts1044893slipouts
slipped124711743slipped
slipper113712973slipper
slipslop1241813slipslop
slipway1543873slipway
slit46250103sli__t
slits56128853sli_ts
slitty9329163slitty
sliver94116593sliver
sloop76118913sl_oop
slop66533873sl__op
slope75823563slop_e
sloped94216853sloped
sloper84615913sloper
slopes84820453slopes
sloppy1395303sloppy
slops75026013slop_s
slub65428033sl__ub
slue45332193sl__ue
slug55124643sl__ug
slum65430513sl__um
slump94816633sl_ump
slur45525153sl__ur
slurp74014983sl_urp
slut45040593sl__ut
slype105112363slyp_e
slypes114410483slypes
snip66424653sni__p
snipe75320573snip_e
sniped94913483sniped
sniper84413643sniper
snipes83917393snipes
snippy1374843snippy
snips75818013snip_s
solidus8338113solidus
soup66232913s__oup
spud75818493s__pud
spue66025523s__pue
spun66221463s__pun
spur65321193s__pur
stickup1533853stickup
stipe76523373stip_e
stiped94517073stiped
stipel84412123stipel
stipes84524053stipes
stipule936723stipule
stirp76815503sti_rp
stirrup943003stirrup
stoup75517073s_toup
sunup7313053s_unup
sup57041943s___up
swipe105217083swip_e
swiped123811093swiped
swipes114114333swipes
swiple11379233swiple
syrup103010963s_yrup

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127161707.58014870.2
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.76623009.4
 
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.