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

135 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
effects153528(None) 
affects1535391affects
effect1437441effect_
affect1448902affect_
coeffects1942462coeffects
defects134511522defects
deflects14336732deflects
effaces15277272effaces
effected1744992effected
effecter1664772effecter
effecters1764322effecters
effector1644872effector
effectors1755032effectors
effete1235182effe_te
efforts1334702efforts
ejects15409952e_jects
elects83315002e_lects
erects84116182e_rects
expects1866882expects
exsects1655572exsects
infects12279712infects
perfects15107352perfects
refects124012742refects
reflects13288872reflects
advects13276013advects
affected1744793affected
affecter1644523affecter
affecters1763933affecters
afflicts1644003afflicts
afreets1037013afreets
aspects1146743aspects
beflecks1943753beflecks
befrets1237613befre_ts
bisects1137133bisects
buffets15317593buffe_ts
coeffect1843933coeffect_
confects153110873confects
defeats113511233defeats
defect124816173defect_
deffest14308803deffest_
deflect13399973deflect_
dejects17389223dejects
detects104011093detects
directs102710263directs
ebbets10376833ebbe_ts
edicts94911703e_dicts
educts9439893e_ducts
efface14366673effac_e
effaced16225573effaced
effacer15255413effacer
effacers16244233effacers
effecting1845583effecting
effective2076193effective
effectives21134563effectives
effectual1752763effectual
effendi1442423effendi
effendis1542513effendis
efferents1545333efferents
effluents15133443effluents
effort1238623effort_
effs105114033eff___s
effuses1335903effuses
efts76519483e_f__ts
egests74411253e_gests
egrets72712243egre_ts
eject145016043e_ject_
ejecta15337393e_jecta
elect74327033e_lect_
eluents738703eluents
emmets10349153emme_ts
enacts84012973e_nacts
enfaces122110913enfaces
epacts105010393e_pacts
erect74129333e_rect_
eructs83610793e_ructs
events94814073e_vents
everts94514893e_verts
evicts11368553e_victs
exacts15359613e_xacts
excepts1885203excepts
execs14539723e_xec_s
exerts133712293e_xerts
expect1758903expect_
experts1659063experts
exsect1558503exsect_
exserts1467013exserts
extents142610173extents
facets116316653_facets
facts107021893__facts
faeces114713123_faeces
feats86432753__feats
feces105625363__feces
fecks145417853__fecks
felts85324543__felts
fests85828043__fests
fets75345943__fe_ts
flecks154310803_flecks
fleets96915063_fleets
frets85523403_fre_ts
haffets1636053haffe_ts
infect113413443infect_
infests10279793infests
inflects1336193inflects
injects16257453injects
insects93710843insects
neglects1144383neglects
objects18123693objects
offbeats1682813offbeats
offcuts1542573offcuts
offences1645023offences
offends14234293offends
offers12349963offe_rs
offices1536243offices
offsets1333503offsets
perfect141010833perfect_
perfecta15115203perfecta
perfectas16135073perfectas
perfecto15105743perfecto
perfectos16106073perfectos
prefects1598133prefects
redefects1543793redefects
reejects17336083reejects
reelects103110883reelects
reerects10319923reerects
refect114319333refect_
reflect123913713reflect_
reflets103513153refle_ts
refracts13137383refracts
reinfects1444723reinfects
rejects163910693rejects
resects94115593resects
respects1247703respects
sects75622893__sects
selects91912143selects
tuffets13266523tuffe_ts

Search took 7 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 Limit1340271355.76623244.4
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.21828737.7
 
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.