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

148 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
allegers937823(None) 
alleger8319631alleger_
alleges84212571allege_s
alegars838932a_legars
alieners889822alieners
allayers11156632allayers
allees64521482alle_e_s
allege74314652allege__
alleged9389322allege_d
allegory1244292allegory
allegro844852alleg_ro
allegros945082allegros
alleles73812032allele_s
allergens10145172allergens
allovers1137672allovers
allurers8286772allurers
alterers82512492alterers
collegers12256842collegers
legers74518312__legers
acceders1334793acceders
adherers1296923adherers
agers65027853a___gers
aggers85817793a__ggers
alders74218423a_l_ders
alegar739283a_legar_
algors7312553a_l_gors
alienees8118653alienees
aliener71011193aliener_
alienors8136733alienors
aligners9117573aligners
aliners74717723a_liners
alkenes114212753alkene_s
allayer10148213allayer_
allee54932123alle_e__
allegedly1472713allegedly
alleging1038473alleging
allegoric1244113allegoric
allegories1185393allegories
allegorise1183493allegorise
allegorist1184763allegorist
allele64514563allele__
allergen9135893allerge_n
allergies10137783allergies
allergins10146383allergins
alleys95113303all__eys
allies63827673all_ie_s
allobars1046583allobars
allonges937313allonge_s
allotters965563allotters
allover1038583allover_
allseeds943393allseeds
alludes83610333allude_s
allurer7348433allurer_
allures72913113allure_s
almemars1243523almemars
almners9399563a_lmners
almoners1068133almoners
alterer72713993alterer_
alters64924223a_l_ters
ambeers11428923ambe_ers
ameers84015573a_me_ers
ammeters1237693ammeters
angers75222543a__ngers
anlages82414113anlage_s
armigers1135703armigers
ateliers837883ateliers
augers73818703a__ugers
avengers1235583avengers
ballers94421013ball__ers
balloters1157673balloters
billeters1136873billeters
bleeders11448453bleeders
bleepers12377493bleepers
bloggers12397403bloggers
bludgers12397853bludgers
blungers11469843blungers
bulgers105215143bul_gers
callees94117783calle_e_s
callers94221963call__ers
callipers1356493callipers
challengers1752503challengers
clangers114312343clangers
clingers113810663clingers
cloggers12437283cloggers
colleger11227933colleger_
colleges112410523college_s
dalliers93610613dall_iers
egers65120373___egers
fallers103917993fall__ers
falterers12238033falterers
flaggers13328073flaggers
flangers123311373flangers
fleecers13325933fleecers
fleers96015793_fle_ers
flingers123410193flingers
floggers13387863floggers
gallopers12136323gallopers
hallowers15137723hallowers
illegals954323illegals
integers937783integers
jaegers15307103_jaegers
laagers83411253_laagers
labelers10249413labelers
lagers74826143__lagers
laggers94216243_laggers
laveers10329363lave_ers
ledgers94912183_ledgers
leers54828983__le_ers
leger65721513__leger_
leges64427293__lege_s
lepers84817323__lepers
levers94621323__levers
lieges74113443_liege_s
ligers75022043__ligers
lingers84223303_lingers
lodgers95113833_lodgers
loggers94616133_loggers
longers84819543_longers
lugers74617023__lugers
luggers93713483_luggers
lungers83817093_lungers
malingers1285853malingers
mallees93315973malle_e_s
obligers1134723obligers
palterers11249533palterers
parleyers1444703parleyers
pillagers12276923pillagers
pledgers12387643pledgers
pluggers12297023pluggers
plungers11379403plungers
ralliers84010833rall_iers
renegers9248793renegers
salliers83613343sall_iers
salvagers1344693salvagers
sleekers12377993sleekers
sleepers103110113sleepers
slingers93712683slingers
sloggers10418783sloggers
sluggers10348483sluggers
tallages92312003tallage_s
talliers83711373tall_iers
ullages838953ullage_s
veligers1237023veligers
villagers13296153villagers
volleyers1542773volleyers
walleyes1435603walleye_s
wallopers14136273wallopers
wallowers15127653wallowers

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.420425454.8
2DLD Change Limit1461621486.73621698.6
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.20224811.3
 
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.