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

102 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
loiterers93626(None) 
loiterer837081loiterer_
fosterers12238022fosterers
letterers9228112letterers
litterers9228192litterers
lobsterers1243482lobsterers
loitered938182loitere_d
loiters74116612loit__ers
miterers10219682_miterers
potterers11218662potterers
roisterers1045122roisterers
totterers9186812totterers
alterers82512503_alterers
banterers112410013banterers
barterers11269643barterers
batterers113110723batterers
blusterers12174993blusterers
bolsterers1244683bolsterers
borderers1276333borderers
broiderers1343223broiderers
caterers102814413_caterers
clatterers12155423clatterers
coherers132310733co_herers
coverers132712123co_verers
ditherers13196683_ditherers
dodderers1243803dodderers
dotterels1043903dotterels
enterers82214153_enterers
falterers12238043falterers
fetterers12267043fetterers
filterers12206973filterers
flatterers13175913flatterers
flowerers1544503flo_werers
flutterers13184593flutterers
fosterer11239523fosterer_
fritterers13203393fritterers
fruiterers1343003fruiterers
goiters84014443goit__ers
goitres8389563goit_re_s
hostelers1246643hostelers
hoverers14289023ho_verers
latherers12158853latherers
lecturers11124233lecturers
letterer8259223letterer_
libelers10238623l_ibelers
lingerers10126923lingerers
listeners9147333listeners
liteness82213213l_iteness
literals8312293l_iterals
literary1147753l_iterary
liters65429883l_it__ers
litres65220393l_it_re_s
litterer82810173litterer_
litters73422573l_it_ters
liveners11217933l_iveners
loathers113310443loat_hers
lobsterer1144033lobsterer_
lofters103912903loft__ers
loiter64619173loit__er_
loitering1039683loitering
looseners945413looseners
looters74419163loot__ers
lotteries9311083lotteries
lotters73921063lo_t_ters
lumberers13196013lumberers
miterer92511333_miterer_
moisteners1244783moisteners
mutterers11247373mutterers
offerers1434933_offerers
orderers9116563_orderers
oysterers1245573oysterers
palterers11249543palterers
patterers112410133patterers
pesterers112510463pesterers
pewterers14216043pewterers
plasterers1286123plasterers
poitrels1035243poit_rels
ponderers12248453ponderers
porteress1137933porteress
posturers1137053posturers
potterer102310263potterer_
poulterers1244563poulterers
powderers15214793powderers
putterers11238363putterers
quiverers2143713quiverers
roisterer946433roisterer_
shiverers15155773shiverers
sliverers12196363sliverers
slobberers14152883slobberers
softeners1245133softeners
solderers1066533solderers
sorcerers1145323sorcerers
titterers9236993titterers
torturers944343torturers
totterer8217793totterer_
twitterers1342673twitterers
utterers8218653_utterers
waterers112312793_waterers
whiteners1535253whiteners
winterers12209723winterers
witherers15146843_witherers
wonderers13217933wonderers

Search took 9 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 Filter1786911486410.453394461.4
2DLD Change Limit1486411027.90618801.0
3Display Results1021020.0462217.4
 (SQL Overall)1786911028.40521260.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.