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 “clip” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 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
clip8692400(None) 
blip88322771blip
chip116726421chip
clap86429041clap
clips96018301clips
clipt96324271clipt
clop86929891clop
flip96324261flip
lip514755801_lip
slip67031731slip
alif76242132alif
alit46155692alit
alp56641132al_p
blimp115612942blimp
blin67228172blin
blips95615782blips
caid77837532caid
cain65643912cain
calif104929092calif
caliph13311402caliph
calix145317342calix
camp106336452camp
cap76758982c_ap
carp85139812carp
ceil65725062ceil
cep75736332c_ep
chap114928492chap
chi86228652chi_
chia96026622chia
chic115925202chic
chid106626402chid
chimp145216472chimp
chin96934742chin
chips125721252chips
chirp124717162chirp
chis95933312chis
chit96937462chit
chop116024922chop
cig67036182c_ig
cilia73016762cilia
cis57748032c_is
clad76225822clad
clag75924572clag
claim95616912claim
clam86332292clam
clamp115517652clamp
clan65633922clan
claps95626182claps
clapt98027172clapt
clasp95517192clasp
claw95624342claw
clay95927412clay
clef97028182clef
clepe94617382clepe
clept95725772clept
clew95520572clew
click135217952click
cliff135917122cliff
clift106422192clift
climb115413592climb
clime95720892clime
cline76428532cline
cling86424672cling
clink115320042clink
clod76124612clod
clog76123242clog
clomp115615702clomp
clon66232482clon
clops95924852clops
clot66542422clot
cloy96623832cloy
club85819472club
clue65324532clue
clump115517452clump
coif96337902coif
coil66439652coil
coin66645352coin
coir66327242coir
colic95726172colic
colin76231692colin
comp106731252comp
coop87238652coop
cop711162372c_op
coup86729792coup
crap85731842crap
crib86323572crib
crimp115615802crimp
cripe95521142cripe
cris66233432cris
crisp95014622crisp
crit65743712crit
crop87628632crop
cuif96529132cuif
cup76738242c_up
cusp86021062cusp
cylix17448622cylix
dip67848982_dip
drip76223952drip
flap96128702flap
flic96223732flic
flips105117742flips
flir76422202flir
flit76539272flit
flop96925452flop
gip67645362_gip
glia56423152glia
glib79421432glib
glim76026352glim
glop76724632glop
grip76127022grip
hip86750432_hip
ilia46026812ilia
inclip1036822inclip
kip97042132_kip
klik74412652klik
lap58565272_lap
li29948752_li_
lib57750262_lib
lid47453512_lid
lie38264522_lie
limp88432492_limp
lin37967372_lin
lipa68425922_lipa
lipe66839732_lipe
lips67141442_lips
lis37162272_lis
lisp68926872_lisp
lit39377312_lit
lop58255312_lop
nip56945982_nip
olio46829672olio
oxlip1456882oxlip
pip78051042_pip
plie65127392plie
plop86625742plop
quip154818622quip
rip56851302_rip
scrip96619192scrip
ship95228232ship
sip57656012_sip
skip105421742skip
slap66434042slap
slid55828982slid
slim66631952slim
slipe75626132slipe
slips76023722slips
slipt76627482slipt
slit46250102slit
slop66533872slop
snip66424652snip
tip56551222_tip
trip66830392trip
tulip71111692tulip
unclip1046992unclip
whip125521842whip
yip87241172_yip
zip146636222_zip

Search took 1 second 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 Filter178691298720.0802233637.5
2DLD Change Limit298721570.79637527.6
3Display Results1571570.0463413.0
 (SQL Overall)1786911570.922193808.0
 
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.