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

155 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
negator8301067(None) 
legator83011131legator
negater83711961negater
negaton8299141negaton
negators92411171negators
abnegator1243592abnegator
aerator7314842aerator
delator83015022delator
gator64416032__gator
legato72810952legato_
legators92811032legators
legatos82711182legatos
levator10298962levator
megaton10269852megaton
neater64424312ne_ater
negate72915572negat_e
negated93413232negated
negaters9349782negaters
negates83215842negates
negation92913022negation
negatons9299272negatons
negatron9335992negatron
nestor63713422ne_stor
nugatory1245272nugatory
relator74016362relator
senator7313062senator
abator84512713_abator
ablator939843ablator
abnegators1343673abnegators
aerators8315613aerators
animator101410293animator
aviator10229663aviator
avigator12236773avigator
beater84729393be_ater
begat86629723begat__
beglamor1383193beglamor
belabor1136293belabor
bettor83612223be_ttor
chelator1347913chelator
citator9310123citator
creator93714433creator
cremator1269173cremator
curator9312213curator
debater104114693debater
debtor938333de_btor
deflator12328343deflator
delators92314823delators
delegator1146243delegator
deviator1248313deviator
dewater112912423dewater
dilator82712783dilator
donator8310263donator
eater54639843_e_ater
editor738663_editor
elater64724203_elater
elevator1146713elevator
enactor938033enactor
enamor838753_enamor
enervator1245523enervator
engager9278603engager
equator1637483equator
exactor1636623_exactor
feater95224053fe_ater
fellator1176713fellator
fetor81214533fe__tor
fugato1036223fugato_
fugatos1135483fugatos
gater64533653__gater
gators74115833__gators
gelato73812953gelato_
gelatos83111513gelatos
generator1067593generator
genitor837273genitor
gigaton946343gigaton
gyrator1135713gyrator
heater94828303he_ater
hector113312653he_ctor
heritor10310563heritor
indagator1144313indagator
inflator1158033inflator
integrator1157123integrator
lector83514983le_ctor
legate72917453legat_e
legated92513983legated
legatee82814633legatee
legates82917683legates
legation92412933legation
levators11249283levators
locator93110423locator
mediator1139043mediator
megabar1244503megabar
megapod1344893megapod
megaron10248303megaron
megastar1143533megastar
megatons11279703megatons
mentor8414363me_ntor
migrator1147873migrator
narrator847563narrator
natatory1146603natatory
navigator1364883navigator
near45236503ne_a__r
nearer64618893ne_arer
neat46356783ne_at__
neaten64214543ne_aten
neath86020283ne_at_h
neatly93812483ne_atly
neats55931903ne_at_s
nectar838853ne_ctar
negating102012833negating
negations102811963negations
negative1239083negative
negatrons10275843negatrons
neglector1253433neglector
negotiator1153313negotiator
neighbor1442243neighbor
nekton1036583ne_kton
nematic111713993nematic
nematode1155163nematode
nester64124183ne_ster
nestors73614973ne_stors
netop7312343ne__top
netter63722023ne_tter
neuston736083neuston
neuter63713793ne_uter
newton936983ne_wton
nitrator849553nitrator
nonactor1047773nonactor
numerator1145583numerator
operator10310093operator
orator6314533_orator
predator11310053predator
reactor93011653reactor
realtor73611353realtor
rebater93517913rebater
rebato83714683rebato_
rebatos92913113rebatos
rector84019743re_ctor
redactor1147023redactor
regaler83814623regaler
regather1236733regather
regatta835963regatta
regulator1046973regulator
relater73723143relater
relators83316123relators
rogatory1246153rogatory
rotator7310833rotator
seater64534153se_ater
sector83415923se_ctor
sedater83713623sedater
senators8312953senators
stator64015483_stator
testator847373testator
vector113212063ve_ctor
venerator1247263venerator
viator93211833_viator

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.1561145455.1
2DLD Change Limit1340271556.89019452.4
3Display Results1551550.0463369.6
 (SQL Overall)1786911557.09225196.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.