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

114 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
umbrages133662(None) 
umbrage1236721umbrage_
ambages1269622amb_ages
embraces14128862embraces
mirages102213532_mirages
umbrae1038682umbra_e_
umbrageous1552302umbrageous
umbras1038642umbra__s
umpirages1443342umpirages
unbraces12229412unbraces
unbrakes14258412unbrakes
abrades10312073_abrades
adumbrates1553123adumbrates
ambage11510603amb_age_
ambaries123312353ambaries
ambries111614543ambr_ies
ambsaces1455213ambsaces
amirates101114793amirates
amperages1447673amperages
averages1249183averages
barges94528253__barges
barrages11711083barrages
borages103917163_borages
braces108427773__braces
braes75735053__bra_es
brags85625103__brag_s
brakes124923123__brakes
braves115524083__braves
brazes175522193__brazes
cabbages1537203cabbages
courages11311393courages
cubages1237923cub_ages
cumbrances1844213cumbrances
dumbcanes1672773dumbcanes
embargoes1442903embargoes
emblazes2135673emblazes
embrace1388893embrace_
embraced15106673embraced
embracer1496463embracer
embracers15105153embracers
embrangles1543213embrangles
embrues1136473embr_ues
embrutes1245183embrutes
emerges101310883emer_ges
emirates101214843emirates
enrages83114853_enrages
forages114217283_forages
fumarases1443723fumarases
fumarates1445383fumarates
garages9314113_garages
garbages1238183garbages
herbages1437083herbages
images91411463im__ages
imblazes2144723imblazes
imbrues1135503imbr_ues
imbrutes1244203imbrutes
librates103412933librates
lumbagos1343073lumb_agos
mages85036023_m__ages
manages103418963_manages
marges94525713_mar_ges
membranes1545553membranes
menages103615393_menages
merges94122483_mer_ges
metages102714973_metages
milages103114403_milages
mirage92313653_mirage_
moorages1139053moorages
morales93619403_morales
numerates11199553numerates
ombres103911143ombr__es
outbrags1136693outbrag_s
outbraves1436703outbraves
outrages92215933outrages
overages12513833overages
peerages1189883peerages
rages64539443___rages
rummages1344933rum_mages
smaragdes1343033smaragdes
smaragds1243303smaragds
storages9311103storages
subraces12313033subraces
suffrages1644383suffrages
tutorages1045773tutorages
ullages838953u_llages
umbles103817493umb__les
umbones1138013umb_ones
umbra948513umbra___
umbral1038633umbra__l
umbrettes1344143umbrettes
umpirage1343573umpirage_
unbales92914863unb_ales
unbrace111910483unbrace_
unbraced132310433unbraced
unbraids1144953unbraids
unbrake13239123unbrake_
unbraked15289413unbraked
uncages103213773u_ncages
uncrates10314553uncrates
underages11811083underages
undrapes1138603undrapes
unitages938273unitages
upbraids1343543upbraids
upgrades12216063upgrades
uprates93814863u_prates
upstages11147373upstages
urares64519093u__rares
urases63723563u__rases
urates65027763u__rates
urges64619913u__r_ges
usages759603u__sages
vambraces1843753vambraces
vibrates132210593vibrates
webpages1643053webpages

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621147.54619369.5
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.74823062.9
 
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.