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

127 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
polluting123570(None) 
collating12312762collating
colleting12311052colleting
colluding1335902colluding
palleting1238732palleting
pelleting1237952pelleting
pollening1236922pollening
polling102920382poll__ing
pollutant1144202pollutant
pollution1146002pollution
pollutions1245432pollutions
pollutive1444712pollutive
pouting103519942po__uting
alluding1036953_alluding
alluring939073_alluring
balloting1238383balloting
billeting1236633billeting
bolling103820883boll__ing
bollixing1944813bollixing
bolloxing1944773bolloxing
bolting104416763bo_l_ting
bulleting1236643bulleting
callusing1236173callusing
clouting113011683_clouting
collaging1337913collaging
collaring12310543collaring
collecting1548283collecting
colliding1338583colliding
collying14319543coll_ying
colouring1258733colouring
commuting16288443commuting
computing16309853computing
confuting1539093confuting
diluting10248983_diluting
dolling93817373doll__ing
dolloping1344993dolloping
dollying13407413doll_ying
eluting84115293__eluting
fellating1339243fellating
filleting1335843filleting
flouting122610473_flouting
fluting113815093__fluting
foliating1339253foliating
following1665753following
galleting1137623galleting
glouting10379693_glouting
hollaing12167093holl_aing
hollering1337743hollering
holloaing1385793holloaing
holloing12148823holl_oing
hollooing1385363hollooing
hollowing1675933hollowing
illuding1035803_illuding
illuming1135873_illuming
jollying19316053joll_ying
jolting153410913jo_l_ting
lolling83415773loll__ing
lolloping1244683lolloping
louting83719383__louting
luting75221753___luting
molesting1237753molesting
molting103517173mo_l_ting
moulting112710313moul_ting
nonpolluting1552043nonpolluting
outing74128153_o__uting
palliating1347883palliating
palling104024483pall__ing
palpating1438533palpating
pelting102917273p_el_ting
permuting1446553permuting
pillaging1345553pillaging
pillaring1237643pillaring
pilling103722563pill__ing
pillowing1545493pillowing
piloting1139693p_iloting
plaiting113113513p_laiting
planting113515383p_lanting
plating103823073p__lating
platting114813033p_latting
pleating112916053p_leating
plotting113011013p_lotting
pluming123412043p__luming
pocketing1875853pocketing
pointing112813683po_inting
poleaxing1944873poleaxing
policing13311673po_licing
poling93526503po_l__ing
polishing1536923polishing
polkaing1534633po_lkaing
pollarding1444233pollarding
pollenating1444553pollenating
pollinating1445613pollinating
pollutants1252613pollutants
pollute937383pollut__e
polluted1135433pollut_ed
polluter1035403pollut_er
polluters1135033polluters
pollutes1037613pollut_es
pooling103219093pool__ing
populating1547663populating
porting103021783po__rting
positing11312303po_siting
posting105622243po__sting
posturing1238993posturing
pothunting1643653pothunting
potting103720893po__tting
pouring103115863po__uring
poutine93316823po__utine
preluding1337053preluding
pulling103821073pull__ing
pullulating1442953pullulating
pulsating1236343pulsating
rolling83620413roll__ing
routing83821093ro__uting
saluting9310553_saluting
solating9315593so_lating
solvating1336443solvating
spoliating1366963spoliating
spouting113511953spo__uting
toileting1036263toileting
tolling83418563toll__ing
touting84118453to__uting
umlauting1243163umlauting
volleying1643763volleying
voluming1435043vo_luming
volutin1098103vo_lutin_
volutins1188003vo_lutins

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411276.51622811.7
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.98225593.1
 
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.