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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

201 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
ligers7502202(None) 
lagers74826141lagers
legers74518311legers
libers84721431libers
liers55130401li_ers
lifers95617841lifers
liger65024461liger_
likers104620911likers
liners65428841liners
lingers84223291lingers
liters65429871liters
livers94927821livers
lugers74617021lugers
tigers75616501tigers
agers65027852_agers
aggers85817792aggers
aiders74524632aiders
aimers84621912aimers
airers64922312airers
aivers94822322aivers
aligners9117562aligners
aliners74717722aliners
angers75222542angers
augers73818702augers
biders94822802biders
biers76225222bi_ers
bikers124517552bikers
biners85023632biners
bingers104519982bingers
biters83925232biters
cagers95624182cagers
ciders94620082ciders
cigars9910712cigars
citers85022972citers
clingers113810652clingers
clivers123411752clivers
dicers94720742dicers
diggers104413382diggers
dikers114418792dikers
dimers94321092dimers
diners75525952diners
dingers94321372dingers
divers105024962divers
eagers74523682eagers
edgers84413912edgers
egers65120372_egers
eggers84612582eggers
eiders74321362eiders
fibers114717522fibers
fifers125414922fifers
filers94623722filers
fingers113418422fingers
firers94922682firers
fivers124420922fivers
fixers165112982fixers
fliers94417192fli_ers
flingers123410182flingers
gagers84021322gagers
gibers95114662gibers
gingers94118632gingers
givers104817712givers
gliders94811842gliders
hiders104919652hiders
hikers135014352hikers
hingers113420192hingers
hirers94518062hirers
jagers144415722jagers
jibers155912882jibers
jiggers164010172jiggers
jivers164515642jivers
kiers95320092ki_ers
kiters105218582kiters
laagers83411252laagers
lacers85225252lacers
laders74927762laders
lager65132862lager_
laggers94216242laggers
lakers105225152lakers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
ledgers94912172ledgers
leers54828982l_eers
leger65721502leger_
leges64427282lege_s
lepers84817322lepers
levers94621322levers
liars54723162li_ars
libbers113812822libbers
libels85112692libels
liber74723612liber_
lickers134118252lickers
lidars7310782lidars
lieges74113442lieges
liens56525502li_ens
lier45942462li_er_
lies46454192li_e_s
lieus56218482li_eus
lifer85822152lifer_
lifters104313772lifters
ligans76817732ligans
lighters123111372lighters
lights104519912lights
ligure7279472ligure
ligures8269882ligures
likens105613702likens
liker95627062liker_
likes96231902like_s
limbers113614722limbers
limens84618032limens
limes75636502lime_s
limeys11429272limeys
limmers113413082limmers
limners93311552limners
limpers113815222limpers
linens64818392linens
liner55938912liner_
lines57054572line_s
linger75225992linger_
linkers114317702linkers
linters73822612linters
lippers113416432lippers
lispers94514322lispers
listers74026522listers
liter54736342liter_
litres65220392litres
litters73422562litters
livens94314892livens
liver85132962liver_
livery124910892livery
lives86133192live_s
liviers104211072liviers
livres94311862livres
livyers13365902livyers
lodgers95113832lodgers
loges66534202loge_s
loggers94616132loggers
loiters74116612loiters
loners64225802loners
longers84819532longers
lopers84424142lopers
losers65123582losers
lovers94223432lovers
lowers94624922lowers
luger65322082luger_
luges65928752luge_s
luggers93713482luggers
lungers83817082lungers
lurers64217492lurers
milers84625162milers
mimers105520182mimers
miners84126632miners
misers85025702misers
miters84328772miters
mixers154513562mixers
niggers93111312niggers
niters64624202niters
obligers1134712obligers
oilers64721192oilers
pagers94423252pagers
piers75926332pi_ers
pikers124717392pikers
pingers104020732pingers
pipers104318662pipers
pliers84715152pli_ers
ricers84120992ricers
riders74123902riders
riggers93613832riggers
rigors72813712rigors
rimers84522552rimers
ringers83922942ringers
risers64624782risers
rivers94626542rivers
rogers74517912rogers
sighers113712172sighers
signers84714422signers
singers83824692singers
sivers95324152sivers
sizers155215812sizers
slicers94114922slicers
sliders83515222sliders
slingers93712672slingers
slivers104115252slivers
tiers55526522ti_ers
tiger65718632tiger_
tilers63523492tilers
timers84420992timers
titers64526402titers
urgers73313622urgers
veligers1237022veligers
viers85621952vi_ers
vigors102911482vigors
vipers114914532vipers
vivers124717362vivers
wagers105122202wagers
wingers113921472wingers
wipers115416082wipers
wirers94617892wirers
wivers125320802wivers
yagers105114532yagers
zingers173514842zingers

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825512012.64031269.3
3Display Results2012010.0633190.5
 (SQL Overall)1786912012.81363523.3
 
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.