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

107 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
predators1231009(None) 
predator11310061predator_
predatory1547711predatory
creators102814422cre_ators
creditors1245882creditors
cremators1369832cremators
depredators1543742depredators
precatory1649122precatory
predates11615822predat_es
predations13812152predations
predictors1547272predictors
prefatory1746692prefatory
pretors9316812pre__tors
pronators11411302pronators
redactors1247542_redactors
relators83316142_relators
aerators8315623_aerators
chelators1448173chelators
coeditors1245803coeditors
creator93714453cre_ator_
creditor1145913creditor_
cremator1269203cremator_
crematory1647223crematory
delators92314833_delators
depredator1443983depredator_
depredatory1853173depredatory
editors839423__editors
elevators1246313elevators
emendators1344203emendators
erectors103514263ere_ctors
graduators1244233graduators
laudators1045893laudators
legators92811033_legators
levators11249293_levators
mandators1247873mandators
mediators1248933_mediators
negators92411173_negators
operators11410753operators
orators7313823or__ators
palpators1346813palpators
pedagogs13123793p_edagogs
pedalers11239393p_edalers
pedalos10329703p_edalo_s
permeators1447403permeators
perorators1249353perorators
piscators1347083piscators
pleaters103613793ple_aters
pledgeors13313083pledgeors
pledgors12325263pled_gors
praetors1039833pr_aetors
praters94921653pr__aters
prealters1147773prealters
preavers13910263pre_avers
precentors1488343precentors
preceptors1657053preceptors
predaceous1553943predaceous
predacious1544773predacious
predate10616893predat__e
predated12513273predat_ed
predating13514653predating
predation12313463predation
predatism1447293predatism
predatisms1545253predatisms
predawns1444363preda_wns
predeaths1544753predeat_hs
predicatory1945573predicatory
predictor1447103predictor_
preemptors1644233preemptors
prefacers1636293prefacers
preheaters1557193preheaters
prelates10418583prelat_es
prelature1146273prelature
prelatures1245733prelatures
prelectors1447883prelectors
premature1347793premature
prematures1447063prematures
preparators1554723preparators
preparers13197673preparers
presagers1236943presagers
pressors103212693pre_ssors
presters103419003pre_sters
prestore104217353pre_store
prestores114716083pre_stores
prestos93716093pre_sto_s
pretor8315753pre__tor_
previsors14126503previsors
probatory1647113probatory
proctors12311513pr_octors
pronator10311783pronator_
pronatores1247373pronatores
pulsators1175373pulsators
radiators1049343_radiators
reactors103212293_reactors
realtors82811683_realtors
rebaters103413943_rebaters
rebatos92913133_rebato_s
rectors93520523_re_ctors
redactor1147033_redactor_
redates83423883_redat_es
redtops1037373_red_tops
reductors1246523_reductors
relaters83218153_relaters
relator74016383_relator_
rotators8310203_rotators
senators8312953_senators
treaters83615853tre_aters
urinators947633urinators

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.423422437.4
2DLD Change Limit1486411076.87621617.4
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.34524328.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.