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

175 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
rotators831020(None) 
rotator7310831rotator_
rotatores946481rotatores
rotatory1147211rotatory
citators10310252citators
donators9310402donators
locators102910432locators
orators7313822_orators
potatoes1039942potatoes
potatory1348412potatory
pronators11411302pronators
relators83316132relators
rogatory1246152rogatory
rotates72819772rotat_es
rotations91613842rotations
rotors64917952ro__tors
rotters74421392rot_ters
stators73915582_stators
abators94413093_abators
ablators1069883ablators
abrogators1345223abrogators
actuators1146443actuators
aerators8315613aerators
agitators1046623agitators
annotators1084423annotators
arrogators1145373arrogators
aviators11169903aviators
bettors93312473bet_tors
boaters93419243bo_aters
bottoms1136993bot_toms
citator9310123citator_
citatory1347213citatory
coactors1239483coactors
coaters93525793co_aters
cofactors1645943cofactors
cogitators1346003cogitators
collators11410343collators
contactors1448843contactors
copastors1346993copastors
cottars94412243cot_tars
cotters94323443cot_ters
cottons9312193cot_tons
creators102814413creators
cremators1369823cremators
curators10311723curators
delators92314833delators
dictators1247363dictators
dilators93213203dilators
doctors1039993do_ctors
donator8310263donator_
dotations101411633dotations
dotters83715973dot_ters
equators1737473equators
evocators1446713evocators
foetors1039763fo_etors
gators74115843__gators
grottoes9276753grot_toes
grottos8337333grot_to_s
gyrators1246003gyrators
hortatory1544743hortatory
idolators1046283idolators
imitators1147013imitators
irritators1045133irritators
isolators947513isolators
jotters143413803jot_ters
legators92811033legators
levators11249283levators
locaters102710073locaters
locator93110423locator_
lotters73921063lot_ters
lottos64613103lot_to_s
matadors1156983matadors
monitors10310823monitors
moratory1347823moratory
motivators1545183motivators
motors84616603mo__tors
mottoes93412193mot_toes
mottos84615243mot_to_s
natatory1146613natatory
negators92411173negators
nitrators949213nitrators
nonactors1147883nonactors
notates72817483notat_es
notations91512973notations
oaters65029793_o_aters
orator6314533_orator_
oratory1039403_oratory
ottars64112223_ot_tars
otters64021513_ot_ters
ottos54714323_ot_to_s
perorators1249353perorators
potations111615073potations
potato8513433potato__
potters94024343pot_ters
pottos84615873pot_to_s
predators12310083predators
probatory1647113probatory
proctors12311513pro_ctors
pronator10311783pronator_
pronatores1247373pronatores
protectors142010143protectors
protestors12169313protestors
protractors1546623protractors
rabatos93010903rabato_s
radiators1049323radiators
raptors94213353r_aptors
ratatats846063ratatats
raters63936583r__aters
ratos55528763r__ato_s
ratters74422473rat_ters
rattons73815323rat_tons
razors154711663r__azors
reactors103212293reactors
realtors82811683realtors
rebaters103413943rebaters
rebatos92913113rebato_s
rectors93520523r_ectors
redactors1247543redactors
relaters83218153relaters
relator74016373relator_
renovators1344843renovators
resonators1045813resonators
retailors9285363retailors
retakers123511133retakers
retractors12158583retractors
rhetors1038513r_hetors
ritters74020623rit_ters
roamers93713463ro_amers
roarers73812743ro_arers
roars55622243ro_a__rs
roasters83615933roasters
robalos937683robalo_s
rogations101510823rogations
roisters83615553roisters
romanos94311483romano_s
rooftops13152913rooftops
roosters83514663roosters
rooters74522933ro_oters
rosters73727543ro_sters
rotameters1245033rotameters
rotaries8315693rotaries
rotary92411303rota__ry
rotas54827723rota___s
rotate63320343rotat__e
rotated82715293rotat_ed
rotating92614553rotating
rotation81615453rotation
rotative11310343rotative
rotavirus1242883rotavirus
rotifers1136043rotifers
rotiform1344663rotiform
rotor55519733ro__tor_
rotos56027883ro__to_s
rotter64325463rot_ter_
rottes64524833rot_t_es
rousters84315683rousters
routers74822873ro_uters
roysters113610533roysters
rubatos9278653rubato_s
senators8312953senators
staters73922343_staters
stator64015483_stator_
tabors84517113__tabors
tatars64619793__tatars
taters64932203__taters
testators947333testators
titrators948383titrators
tomatoes1038613tomatoes
totters74618733tot_ters
trotters83310243trot_ters
tutors6912333__tutors
urinators947633urinators
viators102712023_viators
violators1246583violators
vitiators1246923vitiators

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.406440125.6
2DLD Change Limit1461621757.39019778.3
3Display Results1751750.0632777.8
 (SQL Overall)1786911757.85922737.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.