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

125 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
abridge113569(None) 
abridged1343901abridged
abridger1243801abridger
abridges1245301abridges
bridge103711881_bridge
abide86223712ab_id_e
abrade9313052abrad_e
abridgers1343292abridgers
bride86425532_brid_e
bridged12339032_bridged
bridges113911332_bridges
bridle94115462_bridle
fridge11379252_fridge
parridge1254332parridge
ridge75018672__ridge
abided105313313ab_ided
abider95314463ab_ider
abides94719893ab_ides
ablings1038743ablings
abode85518813ab_od_e
abraded1138643abraded
abrader1038643abrader
abrades10312073abrades
abri65522213abri___
abridging1443853abridging
abridgment1653513abridgment
abris75722603abri__s
abying124410413abying_
accidie1247733accidie
acreage1037843acreage
acrid86920103acrid__
acrider1038623acrider
acridine1139553acridine
acridly13396533acridly
adjudge1742613adjudge
aerie54634603aeri__e
aide56045003a__id_e
airing74927503airing_
airings83913843airings
amide86128483a_mid_e
arid57642713a_rid__
arider74717743a_rider
aridly105513703a_ridly
ariose64818723a_riose
arise56436433a_ri_se
arrange838683arrange
arrive91311793arri_ve
aside65122083a_sid_e
astride8311973astrid_e
astringe938223astringe
auricle9139813auricle
azide155617163a_zid_e
badge94819693_b_adge
barde85330773bar_d_e
barege94713543bar_ege
barge85631023bar__ge
baring95135853baring_
barite84224813bari_te
barrage10710843barrage
beige81515383_bei_ge
bide76041503_b_id_e
bilge87618913_b_ilge
binge85125513_b_inge
birdie94013783_birdie
bludge104210973_bludge
boride9415903borid_e
brede85520503_bred_e
bribe94820783_bri_be
bribee104316363_bribee
bridal9511453_bridal
brides94423513_brides
bridled113611143_bridled
bridler103811073_bridler
bridles104114473_bridles
brie65837903_bri__e
brig76528033_bri_g_
brigs85823223_bri_gs
brindle104210103_brindle
brine75132273_bri_ne
bring85528503_bring_
bringer104213353_bringer
brings94618433_brings
budge94619883_b_udge
cabriole1276933cabriole
carbide126112493carbid_e
carriage1137853carriage
cartridge1372723cartridge
cringe93515483_cringe
debride1138593debrid_e
deride84420033derid_e
drawbridge185813drawbridge
dredge9308563_dredge
drudge9317903_drudge
fidge104516063__fidge
flybridge1951353flybridge
fridges12369483_fridges
fringe104013953_fringe
gride75223583_grid_e
grudge9388583_grudge
hagride1237553hagrid_e
hayride1437323hayrid_e
langridge1242233langridge
marriage1147253marriage
midge95016553__midge
oblige937653obli_ge
parridges1384553parridges
partridge1362863partridge
porridge1243763porridge
pride84724733_prid_e
ride55945133__rid_e
ridged94014223__ridged
ridgel8399973__ridgel
ridges85817013__ridges
ridgy104110643__ridgy
sabring102614843sabring_
skybridge2051123skybridge
smidge10378483_smidge
springe103913983springe
stride75420963strid_e
syringe11349473syringe
triage72812893_triage
trudge8318733_trudge
unabridged1542093unabridged
unbridged1453923unbridged
unbridle1145393unbridle

Search took 7 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 Filter1786911340270.453394461.4
2DLD Change Limit1340271256.23321502.8
3Display Results1251250.0462717.4
 (SQL Overall)1786911256.73226543.5
 
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.