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
rotator731082(None) 
rotators8310181rotators
rotatory1147201rotatory
citator9310112citator
donator8310262donator
locator93110422locator
orator6314532_orator
potato8513432potato_
potatory1348412potatory
pronator10311772pronator
relator74016362relator
rogatory1246142rogatory
rotate63320342rotat_e
rotated82715292rotated
rotates72819772rotates
rotation81615452rotation
rotatores946452rotatores
rotor55519732ro__tor
rotter64325462rot_ter
stator64015472_stator
abator84512713_abator
ablator939843ablator
abrogator1245363abrogator
actuator1046643actuator
aerator7314843aerator
agitator946713agitator
annotator974253annotator
arrogator1045253arrogator
aviator10229663aviator
bettor83612223bet_tor
boater84622093bo_ater
bottom1048713bot_tom
citators10310233citators
citatory1347203citatory
coactor1139113coactor
coater84329553co_ater
cofactor1545753cofactor
cogitator1245863cogitator
collator10310373collator
contactor1348423contactor
copastor1246343copastor
cottar84613813cot_tar
cotter84926673cot_ter
cotton8312993cot_ton
creator93714433creator
cremator1269173cremator
curator9312213curator
delator83015023delator
dictator1147263dictator
dilator82712783dilator
doctor938993do_ctor
donators9310383donators
dotation91412733dotation
dotter74419343dot_ter
equator1637483equator
evocator1346573evocator
foetor939563fo_etor
gator64416033__gator
grotto7349813grot_to_
grottos8337333grot_tos
gyrator1135713gyrator
hortatory1544743hortatory
hotter94720073hot_ter
idolator946243idolator
imitator1047113imitator
irritator945223irritator
isolator847533isolator
jotter134315633jot_ter
legator83011133legator
levator10298963levator
locater93113603locater
locators102910413locators
lotter64025603lot_ter
lotto55217573lot_to_
lottos64613103lot_tos
matador1066253matador
monitor9310723monitor
moratory1347823moratory
motivator1445103motivator
motor75317293mo__tor
motto76119513mot_to_
mottos84615243mot_tos
natatory1146603natatory
negator83010673negator
nitrator849553nitrator
nonactor1047773nonactor
notate63217863notat_e
notated82713663notated
notates72817483notates
notation81414603notation
oater55433733_o_ater
orators7313803_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
probatory1647103probatory
proctor11310433pro_ctor
prolabor1284533prolabor
pronators11411273pronators
protatic12314743protatic
protector13169533protector
protestor11178493protestor
protractor1446253protractor
rabato83413263rabato_
rabatos93010893rabatos
radiator949203radiator
raptor83912823r_aptor
ratatat7412263ratatat
rater54943283r__ater
rato45436973r__ato_
ratos55528763r__atos
ratter64326313rat_ter
ratton64116123rat_ton
razor143012603r__azor
reactor93011653reactor
realtor73611353realtor
rebater93517903rebater
rebato83714683rebato_
rebatos92913093rebatos
rector84019743r_ector
redactor1147023redactor
relater73723143relater
relators83316113relators
renovator1244903renovator
resonator946363resonator
retailor8285223retailor
retaker113714313retaker
retractor11218513retractor
rhetor938063r_hetor
ritter63822413rit_ter
roamer84715163ro_amer
roar46328573ro_a__r
roarer63914333ro_arer
roaster74116663roaster
robalo838923robalo_
robalos937673robalos
rogation91612053rogation
roister73516203roister
rolltop944043rolltop
romano84912943romano_
romanos94311473romanos
rooftop12133253rooftop
rooster74415173rooster
rooter64926033ro_oter
roster64329083ro_ster
rota45834343rota___
rotameter1145443rotameter
rotary92411303rota_ry
rotas54827723rota__s
rotating92614553rotating
rotations91613843rotations
rotative11310343rotative
rotifer1036993rotifer
rotiform1344663rotiform
roto45935053ro__to_
rotors64917933ro__tors
rotos56027883ro__tos
rotte54625933rot_t_e
rotted74524433rot_ted
rotten64115433rot_ten
rotters74421393rot_ters
rottes64524833rot_tes
rouster73517083rouster
router65025843ro_uter
royster103110533royster
rubato8319673rubato_
rubatos9278643rubatos
senator7313063senator
stater64427553_stater
stators73915553_stators
tabor75518393__tabor
tatar56122063__tatar
tater54138613__tater
testator847373testator
titrator858543titrator
tomato8313453tomato_
totter65021463tot_ter
trotter73312253trot_ter
tutor5712493__tutor
urinator847843urinator
viator93211833_viator
violator1146283violator
vitiator1147043vitiator

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 Limit1340271926.79619721.5
3Display Results1921920.0633047.6
 (SQL Overall)1786911927.01525472.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.