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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
clipt9632427(None) 
clapt98027171clapt
clept95725771clept
clift106422191clift
clip86924001clip_
clips96018301clips
slipt76627481slipt
alist56136782alist
alit46155692ali_t
blip88322772blip_
blips95615782blips
caliph13311402caliph
chapt125827642chapt
chip116726422chip_
chips125721252chips
chit96937462chi_t
cist67244972c_ist
clap86429042clap_
claps95626182claps
claspt104513412claspt
clast76030582clast
cleat76335062cleat
cleft106222852cleft
clepe94617382clepe
click135217952click
client8316342client
cliff135917132cliff
clifts11519152clifts
climb115413592climb
clime95720892clime
cline76428532cline
cling86424672cling
clink115320042clink
cloot76127052cloot
clop86929892clop_
clops95924852clops
clot66542422cl_ot
clout75330462clout
coapt96131532coapt
compt116328222compt
coopt95929852coopt
crept95125892crept
cripe95521142cripe
crit65743712cri_t
crypt123715232crypt
dipt77339332_dipt
dript86923872dript
elint55436472elint
flint87333502flint
flip96324262flip_
flips105117742flips
flirt87424752flirt
flit76539272fli_t
glint66830182glint
gript85126172gript
lept66440882_lept
lift76942732_lift
lilt46349952_lilt
lint416266242_lint
lip514755812_lip_
lipa68425932_lipa
lipe66839742_lipe
lips67141452_lips
list47055352_list
lit39377322_li_t
script105717902script
slept75728102slept
slip67031732slip_
slipe75626132slipe
slips76023722slips
slit46250102sli_t
whipt135317422whipt
yclept1336012yclept

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit53800732.06326078.5
3Display Results73730.0164562.5
 (SQL Overall)178691732.39274703.6
 
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.