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

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

96 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
velcro114413(None) 
velcros1244031velcros
telco7511872telc_o
velar85817632velar_
velars93913722velars
velure939772velure
aero45435343ae__ro
belch124415503belc_h
belfry1435073belfry
bolero8412093bolero
celery1139623celery
cello74919583cel_lo
cero66329453ce__ro
claro75018693_claro
deco76125973de_c_o
decor84717573de_cor
decry115514353de_cry
descry1256183descry
dextro1436123dextro
echo96615953_e_cho
ecru65819533_e_cru
electro92810033_electro
escrow1135913_escrow
euro45325273_e_uro
fulcra1135213fulcra
gecko124511113ge_cko
gelato73812963gelato
gelcap1136213gelcap
genro64914033ge_nro
helio85321193hel_io
hello86522983hel_lo
helo75332853hel__o
hero74635783he__ro
hetero9312633hetero
jello126716273jel_lo
macro94718173_macro
metro74718803me_tro
micro94715993_micro
mucro94513723_mucro
overcrop1545773overcrop
pedro8313153pe_dro
peltry11288653peltry
recto74520803re_cto
reecho11318653reecho
repro75315913re_pro
retro55020953re_tro
rezero1578873rezero
secco9312423se_cco
telcos8710683telcos
valor83614893valor_
valors93413773valors
vealer94016543vealer_
vealers103214293vealers
vector113212063ve_ctor
veer76229573ve_er_
veers84521363ve_ers
veery115816253ve_ery
veiler93814353veiler_
veilers103911823veilers
vela75725543vel__a
velaria1038923velaria
velate93720143velate
veld85323203vel__d
velds95615583vel_ds
veldt94819863vel_dt
veldts10417753veldts
vellum1136773vellum
veloce11310133veloce
velour9328763velour
velours10278083velours
velum10713383vel_um
velured1136683velured
velures1039093velures
velvet123613753velvet
vendor10359803vendor
venery123710663venery
venire93513693venire
vera76828843ve__ra
verb96224873ve__rb
verso85314633ve_rso
vert77249373ve__rt
very108025643ve__ry
vestry1238623vestry
vetch134411843vetc_h
veto76622993ve__to
vexer155513523vexer_
vexers165210403vexers
viler86324163viler_
volar86917413volar_
volcano1244613volcano
volery1237873volery
vulgo936953vul_go
welch134411493welc_h
weldor10317653weldor
wilco1039443wilc_o
zero134822473ze__ro

Search took 10 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.390458182.1
2DLD Change Limit112716969.15612310.6
3Display Results96960.0462087.0
 (SQL Overall)178691969.59218629.2
 
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.