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

117 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
predator1131005(None) 
predators12310081predators
predatory1547701predatory
creator93714442cre_ator
creditor1145902creditor
cremator1269192cremator
depredator1443972depredator
precatory1649112precatory
predate10616892predat_e
predated12513272predated
predates11615812predates
predation12313462predation
predictor1447092predictor
prefatory1746682prefatory
pretor8315752pre__tor
pronator10311782pronator
redactor1147032_redactor
relator74016372_relator
aerator7314843_aerator
chelator1347923chelator
coeditor1145723coeditor
creators102814413cre_ators
creditors1245873creditors
cremators1369823cremators
crematory1647213crematory
delator83015033_delator
depredators1543733depredators
depredatory1853163depredatory
editor738663__editor
elevator1146713elevator
emendator1244243emendator
erector93513813ere_ctor
graduator1144573graduator
greater84416493gre_ater
laudator945883laudator
legator83011133_legator
levator10298963_levator
mandator1148183mandator
mediator1139043_mediator
negator83010673_negator
operator10310093operator
orator6314533or__ator
palpator1247133palpator
pedagog12113763p_edagog
pedaler103410693p_edaler
pedalo93811153p_edalo_
pedalos10329703p_edalos
pedate93117763p_edat_e
permeator1347403permeator
perorator1149743perorator
piscator1246923piscator
pleater93916333ple_ater
pledgeor12303463pledgeor
pledgor11334993pled_gor
praetor938973pr_aetor
prater84825353pr__ater
prealter1048863prealter
preaver121011613pre_aver
precentor1348733precentor
preceptor1547323preceptor
predating13514653predating
predations13812153predations
predatism1447283predatism
predawn1335353preda_wn
predawns1444363predawns
predeath1447003predeat_h
predeaths1544743predeaths
predicatory1945563predicatory
predictors1547263predictors
preemptor1544153preemptor
prefacer1537983prefacer
preheater1448913preheater
prelate9519693prelat_e
prelates10418573prelates
prelatic12311293prelatic
prelature1146273prelature
prelector1348093prelector
premature1347793premature
prenatal1048373prenatal
preparator1445243preparator
preparer12169643preparer
presager1138443presager
pressor93512883pre_ssor
prester93519623pre_ster
presto84216203pre_sto_
prestore104217353pre_store
prestos93716083pre_stos
pretors9316813pre__tors
previsor13116303previsor
prewar114712583prewa__r
privater13158533privater
probatory1647113probatory
proctor11310433pr_octor
prolabor1284543prolabor
pronators11411303pronators
pulsator1085693pulsator
radiator949203_radiator
reactor93011663_reactor
realtor73611353_realtor
rebater93517913_rebater
rebato83714683_rebato_
rebatos92913123_rebatos
rector84019753_re_ctor
redactors1247543_redactors
redate74124683_redat_e
redated93120923_redated
redates83423873_redates
redtop937973_red_top
reductor1156433_reductor
relater73723143_relater
relators83316133_relators
rotator7310833_rotator
sedater83713633_sedater
senator7313073_senator
traditor945943traditor
treater74219833tre_ater
urinator847843urinator

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 Limit1461621176.70321805.5
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.17224915.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.