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

192 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
rotator731083(None) 
rotators8310201rotators
rotatory1147211rotatory
citator9310122citator
donator8310262donator
locator93110422locator
orator6314532_orator
potato8513432potato_
potatory1348412potatory
pronator10311782pronator
relator74016372relator
rogatory1246152rogatory
rotate63320342rotat_e
rotated82715292rotated
rotates72819772rotates
rotation81615452rotation
rotatores946482rotatores
rotor55519732ro__tor
rotter64325462rot_ter
stator64015482_stator
abator84512723_abator
ablator939853ablator
abrogator1245363abrogator
actuator1046643actuator
aerator7314843aerator
agitator946713agitator
annotator974253annotator
arrogator1045253arrogator
aviator10229663aviator
bettor83612223bet_tor
boater84622093bo_ater
bottom1048723bot_tom
citators10310253citators
citatory1347213citatory
coactor1139133coactor
coater84329573co_ater
cofactor1545763cofactor
cogitator1245863cogitator
collator10310373collator
contactor1348433contactor
copastor1246343copastor
cottar84613813cot_tar
cotter84926673cot_ter
cotton8312993cot_ton
creator93714443creator
cremator1269193cremator
curator9312213curator
delator83015033delator
dictator1147263dictator
dilator82712793dilator
doctor938993do_ctor
donators9310403donators
dotation91412733dotation
dotter74419343dot_ter
equator1637483equator
evocator1346573evocator
foetor939563fo_etor
gator64416043__gator
grotto7349813grot_to_
grottos8337333grot_tos
gyrator1135723gyrator
hortatory1544743hortatory
hotter94720083hot_ter
idolator946243idolator
imitator1047113imitator
irritator945223irritator
isolator847533isolator
jotter134315633jot_ter
legator83011133legator
levator10298963levator
locater93113603locater
locators102910433locators
lotter64025603lot_ter
lotto55217573lot_to_
lottos64613103lot_tos
matador1066253matador
monitor9310723monitor
moratory1347823moratory
motivator1445103motivator
motor75317293mo__tor
motto76119513mot_to_
mottos84615243mot_tos
natatory1146613natatory
negator83010673negator
nitrator849553nitrator
nonactor1047783nonactor
notate63217863notat_e
notated82713663notated
notates72817483notates
notation81414603notation
oater55433733_o_ater
orators7313823_orators
oratory1039403_oratory
ottar54313993_ot_tar
otter54423973_ot_ter
otto45220643_ot_to_
ottos54714323_ot_tos
perorator1149743perorator
potation101716783potation
potatoes1039943potatoes
potter83926983pot_ter
potto75320943pot_to_
pottos84615873pot_tos
predator11310053predator
probatory1647113probatory
proctor11310433pro_ctor
prolabor1284543prolabor
pronators11411303pronators
protatic12314753protatic
protector13169533protector
protestor11178493protestor
protractor1446263protractor
rabato83413263rabato_
rabatos93010903rabatos
radiator949203radiator
raptor83912823r_aptor
ratatat7412263ratatat
rater54943283r__ater
rato45436973r__ato_
ratos55528763r__atos
ratter64326313rat_ter
ratton64116123rat_ton
razor143012603r__azor
reactor93011663reactor
realtor73611353realtor
rebater93517913rebater
rebato83714683rebato_
rebatos92913113rebatos
rector84019753r_ector
redactor1147033redactor
relater73723143relater
relators83316133relators
renovator1244903renovator
resonator946363resonator
retailor8285223retailor
retaker113714313retaker
retractor11218513retractor
rhetor938063r_hetor
ritter63822423rit_ter
roamer84715163ro_amer
roar46328573ro_a__r
roarer63914333ro_arer
roaster74116663roaster
robalo838933robalo_
robalos937683robalos
rogation91612053rogation
roister73516203roister
rolltop944043rolltop
romano84912943romano_
romanos94311483romanos
rooftop12133253rooftop
rooster74415173rooster
rooter64926033ro_oter
roster64329083ro_ster
rota45834343rota___
rotameter1145443rotameter
rotary92411303rota_ry
rotas54827723rota__s
rotating92614553rotating
rotations91613843rotations
rotative11310343rotative
rotifer1036993rotifer
rotiform1344663rotiform
roto45935053ro__to_
rotors64917953ro__tors
rotos56027883ro__tos
rotte54625933rot_t_e
rotted74524433rot_ted
rotten64115433rot_ten
rotters74421393rot_ters
rottes64524833rot_tes
rouster73517083rouster
router65025843ro_uter
royster103110533royster
rubato8319683rubato_
rubatos9278653rubatos
senator7313073senator
stater64427563_stater
stators73915583_stators
tabor75518393__tabor
tatar56122063__tatar
tater54138613__tater
testator847373testator
titrator858543titrator
tomato8313453tomato_
totter65021463tot_ter
trotter73312253trot_ter
tutor5712493__tutor
urinator847843urinator
viator93211833_viator
violator1146283violator
vitiator1147043vitiator

Search took 9 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.420425454.8
2DLD Change Limit1340271927.76617258.2
3Display Results1921920.0633047.6
 (SQL Overall)1786911928.24921662.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.