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

141 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
abvolt1116983(None) 
abvolts12104371abvolts
abbot9318452abbo_t
abort76133582ab_ort
about75229082ab_out
bolt66254172_b_olt
revolt9316222revolt
volt76439532__volt
abaft10318063ab_aft
abbots1039283abbots
abduct11108543abduct
abele76323253ab_ele
abet610547943ab__et
abhor10411063abho_r
abhors11410623abhors
abject17137703abject
ablaut8313263ablaut
able66340533ab__le
ablest84721833ablest
abloom1039783abloom
ably99725133ab__ly
abo59045963ab_o__
abode85518813ab_ode
abohm1247973ab_ohm
aboil72217543ab_oil
abolla8410193abolla
aboma91114603ab_oma
aboon74918703ab_oon
aborts84916183ab_orts
abos67734413ab_o_s
above105414323ab_ove
aboves114512843aboves
abroad9310943abroad
abrupt1039943abrupt
absent84016993absent
absolute1044483absolute
absolve1244513absolve
absorb1038013absorb
abut66834953ab__ut
abwatt11410673abwatt
accost101112263accost
acold86214933a_cold
adopt81219743a_dopt
adroit7518793adroit
adult63520653a_dult
advect12309123advect
advent102613753advent
advert103215783advert
afloat9315153afloat
afoot8420113a_foot
ahold94714253a_hold
aioli5318313a_ioli
aldol61212333aldol_
aldols7109713aldols
allot54933873allo_t
almost81014433almost
aloft8423433a_loft
alt36467963a___lt
alveoli1043583alveoli
amole75724593a_mole
amort75832203a_mort
anole55330383a_nole
anvil82712603anvil_
anvils9219713anvils
aport75432173a_port
areola6813673areola
areole61017283areole
argol65317263argol_
argols74514613argols
argot67728653argo_t
arval86017013arval_
arvo76023433arvo__
arvos86015663arvo_s
ascot76522513asco_t
assort64916383assort
atilt54828473a_tilt
atoll57913923a_toll
avant86224663a_vant
avast85519363a_vast
avert86029493a_vert
avo68936233a_vo__
avocet11412683a_vocet
avoid95516683a_void
avos77227013a_vo_s
avoset9315673a_voset
avow107816463a_vo_w
avows114910983a_vows
awol75620673a_wol_
awols84713523a_wols
azole145118033a_zole
babool103012153babool_
babools11319453babools
ballot84624093ballot
basalt83519583basalt
belt65754033_b_elt
bhoot104322103_bhoot
biont7727163_biont
bloat75229923_bloat
blot65842323_blo_t
boat66360313_b_oat
bola66035563_b_ola
bold75432813_b_old
bole66448693_b_ole
boll65634753_b_oll
bolo65535953_b_olo
bolts76232113_b_olts
boost75132473_boost
boot67759373_b_oot
bort65960963_b_ort
bot59680403_b_o_t
bott66548573_b_ott
bout66353293_b_out
built74325923_built
cavort11316173cavort
colt67158243__colt
devout10712993devout
divot95723073divo_t
dolt56649423__dolt
gavot9321123gavo_t
holt77852583__holt
jabot14321513jab_o_t
jolt116639123__jolt
molt66356163__molt
obol65220613ob_ol_
obole75917143ob_ole
oboli73712873ob_oli
obols73715863ob_ols
obvert11412993obvert
obvolute1342543obvolute
ovoli8358283_ovoli
ovolo8339173_ovolo
pivot106523873pivo_t
revolts1038893revolts
sabot7931783sab_o_t
smolt74824163_smolt
unbolt83013893unbolt
vole75236983__vole
volta85215623__volta
volte85321303__volte
volti84915963__volti
volts85421293__volts

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.373479064.3
2DLD Change Limit1127161414.81323419.1
3Display Results1411410.0304700.0
 (SQL Overall)1786911415.21634258.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.