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

111 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
bagwigs143282(None) 
bagwig1343081bagwig_
bigwigs1443001bigwigs
baggies113814852baggies
baggings13307522baggings
bagnios1036072bagnios
bewigs1246532b_ewigs
bigwig1333342bigwig_
earwigs11104412earwigs
ageings9437693_ageings
aggies83515513_aggies
agings86312673_agings
agios65919863_ag_ios
agrias74315393_agrias
babies106123653ba_bies
backings174012213backings
baddies114017873baddies
baffies153612943baffies
bagass938933bag_ass
bagels95712313bag_els
bagfuls1334753bagfuls
baggage1235633baggage
baggages1335443baggages
baggers113915693baggers
baggie102912193baggi_e
baggier113611643baggier
baggiest123011753baggiest
baggily1436043baggily
bagging123316983bagging
baggy125615683bag__gy
baglike14338943baglike
bagnio937523bagni_o
bagpipe1453113bagpipe
bagpipes1543403bagpipes
bags76645503ba___gs
baguets1037483baguets
bagworm1566353bagworm
bagworms1645213bagworms
bailies94120203bailies
bails75933523ba__ils
baits76630583ba__its
bakings144312023bakings
baldies105317703baldies
ballies93725743ballies
bandies104124863bandies
bandits103814793bandits
bandogs1138363bandogs
bangs85627773ba__ngs
bankings15489403bankings
bankits133410153bankits
banties94324763banties
barbies114519593barbies
bargains1178643bargains
barongs105310833barongs
barrios9310773barrios
bashings144311243bashings
basics104915123ba_sics
basils85717473ba_sils
basins85722763ba_sins
basis75429863ba_si_s
bastings114214693bastings
batiks1239373ba_tiks
battiks1337143battiks
battings114010573battings
batwing13509813batwing
bawdies134613393bawdies
bawds116115493ba_w_ds
bawls105719323ba_w_ls
bawties124214313bawties
begins94415303beg_ins
begrims1276763begrims
bewig1138903b_ewig_
biggies113813523biggies
biggings13327473biggings
biggins113410693biggins
bigs76235023b___igs
blaggings14324463blaggings
bogies94724313bog_ies
bowings133612003b_owings
brewings14296693brewings
brewis11469983brewi_s
brigs85823223b__rigs
buggies114613813buggies
buzzwigs2241093buzzwigs
earwig10114703earwig_
fagins10513863fag_ins
gaywings1633193gaywings
gigs66631183__g_igs
grigs75318193__grigs
haggis11209513haggi_s
jaggies163311083jaggies
jaggs148111493jag__gs
laggings11298403laggings
lapwings14274973lapwings
lawings113611473la_wings
magics115311613mag_ics
magpies12310363magpies
pagings114411063pagings
ragbags1135113ragbags
raggies93214733raggies
raggs75216473rag__gs
ragis66325603rag_i_s
ragtags935373ragtags
rawins95617623ra_wins
swigs96213663__swigs
tagrags936123tagrags
twigs96911173__twigs
waxwings2232953waxwings
wigs84931253___wigs
wigwags1543293wigwags
yagis95416573yag_i_s

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271117.11018850.5
3Display Results1111110.0303700.0
 (SQL Overall)1786911117.54623680.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.