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

138 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
loiterer83708(None) 
loitered938181loitered
loiterers936261loiterers
fosterer11239522fosterer
letterer8259222letterer
litterer82810172litterer
lobsterer1144032lobsterer
loiter64619172loit__er
loiters74116612loiter_s
miterer92511332_miterer
potterer102310262potterer
roisterer946432roisterer
totterer8217792totterer
alterer72713993_alterer
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
batterer102713213batterer
bitterer10309773bitterer
blusterer11176293blusterer
bolsterer1145483bolsterer
borderer1168103borderer
broiderer1244353broiderer
caterer92815943_caterer
clatterer11186983clatterer
cloistered1344513cloistered
coherer122912783co_herer
cottered112511733cottered
coverer123113523co_verer
ditherer12187763_ditherer
dodderer1144203dodderer
dotterel945063dotterel
enterer72015633_enterer
falterer11239853falterer
fetterer11207813fetterer
filterer11258143filterer
flatterer12187673flatterer
flowerer1435453flo_werer
flutterer12185263flutterer
fostered122210453fostered
fosterers12238023fosterers
fritterer12234403fritterer
fruiterer1243333fruiterer
goiter74116203goit__er
goiters84014443goiter_s
goitre7349003goit_re_
goitres8389563goit_res
hosteler1137273hosteler
hoverer13319823ho_verer
latherer111310443latherer
lecturer10136023lecturer
leistered1037043leistered
lettered92910783lettered
letterers9228113letterers
libeler9219003l_ibeler
lieder74912323l_i_eder
liefer9529573l_i_efer
liever94611863l_i_ever
limberer12187053limberer
lingerer9118303lingerer
listener8158313listener
liter54736343l_it__er
literal7613273l_iteral
literary1147753l_iterary
liters65429883l_iter_s
lither94520953l_it_her
litre55421463l_it_re_
litres65220393l_it_res
litter64324853l_it_ter
littered92511383littered
litterers9228193litterers
littler7348553l_ittler
livener10278943l_ivener
livered113111633l_ivered
loather103711003loat_her
lobstered1244643lobstered
lobsterers1243483lobsterers
lofter94614723loft__er
lofters103912903lofter_s
loftier1037763loft_ier
loitering1039683loitering
loosener845633loosener
looter64222323loot__er
looters74419163looter_s
loppered13326753loppered
lotter64025603lo_t_ter
lotteries9311073lotteries
lotters73921063lotter_s
lottery10389833lotter_y
louvered1244993louvered
lowered112711913lo_wered
lumberer12177583lumberer
lustered92510603lustered
mitered103213233_mitered
miterers10219683_miterers
moistener1145843moistener
mutterer10218913mutterer
offerer1335543_offerer
oftener1035923_oftener
orderer8127943_orderer
oysterer1136103oysterer
palterer102411273palterer
patterer103112173patterer
pesterer102412703pesterer
pewterer13256313pewterer
plasterer1178103plasterer
poitrel936193poit_rel
ponderer112410193ponderer
portered112311543portered
posturer1038923posturer
pottered112311663pottered
potterers11218663potterers
poulterer1145423poulterer
powderer14245593powderer
putterer10209913putterer
quiverer2044463quiverer
roistered1037643roistered
roisterers1045113roisterers
rottener8216973rottener
shiverer14186663shiverer
sliverer11237633sliverer
slobberer13153443slobberer
soberer93110353so_berer
softener1145613softener
solderer947183solderer
sorcerer1036433sorcerer
titterer8268523titterer
torturer835493torturer
tottered9208703tottered
totterers9186813totterers
twitterer1243303twitterer
utterer71910463_utterer
waitered1238753waitered
waterer103314073_waterer
whitener1435733whitener
winterer112110443winterer
witherer14187953_witherer
wonderer12249183wonderer

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.423422437.4
2DLD Change Limit1461621386.59322169.3
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.07925242.4
 
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.