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
rotators831018(None) 
rotator7310821rotator_
rotatores946451rotatores
rotatory1147201rotatory
citators10310232citators
donators9310382donators
locators102910412locators
orators7313802_orators
potatoes1039942potatoes
potatory1348412potatory
pronators11411282pronators
relators83316112relators
rogatory1246142rogatory
rotates72819772rotat_es
rotations91613842rotations
rotors64917932ro__tors
rotters74421392rot_ters
stators73915552_stators
abators94413073_abators
ablators1069873ablators
abrogators1345213abrogators
actuators1146423actuators
aerators8315613aerators
agitators1046613agitators
annotators1084413annotators
arrogators1145363arrogators
aviators11169903aviators
bettors93312473bet_tors
boaters93419233bo_aters
bottoms1136983bot_toms
citator9310113citator_
citatory1347203citatory
coactors1239453coactors
coaters93525773co_aters
cofactors1645933cofactors
cogitators1345993cogitators
collators11410323collators
contactors1448833contactors
copastors1346983copastors
cottars94412233cot_tars
cotters94323433cot_ters
cottons9312193cot_tons
creators102814383creators
cremators1369783cremators
curators10311703curators
delators92314823delators
dictators1247343dictators
dilators93213173dilators
doctors1039983do_ctors
donator8310263donator_
dotations101411623dotations
dotters83715973dot_ters
equators1737453equators
evocators1446693evocators
foetors1039753fo_etors
gators74115823__gators
grottoes9276753grot_toes
grottos8337333grot_to_s
gyrators1245993gyrators
hortatory1544743hortatory
idolators1046263idolators
imitators1147003imitators
irritators1045123irritators
isolators947493isolators
jotters143413803jot_ters
legators92811023legators
levators11249283levators
locaters102710063locaters
locator93110423locator_
lotters73921063lot_ters
lottos64613103lot_to_s
matadors1156963matadors
monitors10310813monitors
moratory1347823moratory
motivators1545183motivators
motors84616593mo__tors
mottoes93412193mot_toes
mottos84615243mot_to_s
natatory1146603natatory
negators92411153negators
nitrators949203nitrators
nonactors1147863nonactors
notates72817483notat_es
notations91512973notations
oaters65029783_o_aters
orator6314533_orator_
oratory1039403_oratory
ottars64112223_ot_tars
otters64021513_ot_ters
ottos54714323_ot_to_s
perorators1249343perorators
potations111615063potations
potato8513433potato__
potters94024343pot_ters
pottos84615873pot_to_s
predators12310073predators
probatory1647103probatory
proctors12311493pro_ctors
pronator10311773pronator_
pronatores1247353pronatores
protectors142010123protectors
protestors12169293protestors
protractors1546593protractors
rabatos93010893rabato_s
radiators1049313radiators
raptors94213353r_aptors
ratatats846063ratatats
raters63936573r__aters
ratos55528763r__ato_s
ratters74422473rat_ters
rattons73815323rat_tons
razors154711653r__azors
reactors103212283reactors
realtors82811683realtors
rebaters103413913rebaters
rebatos92913093rebato_s
rectors93520513r_ectors
redactors1247533redactors
relaters83218143relaters
relator74016363relator_
renovators1344833renovators
resonators1045813resonators
retailors9285343retailors
retakers123511133retakers
retractors12158573retractors
rhetors1038513r_hetors
ritters74020613rit_ters
roamers93713453ro_amers
roarers73812733ro_arers
roars55622233ro_a__rs
roasters83615913roasters
robalos937673robalo_s
rogations101510823rogations
roisters83615543roisters
romanos94311473romano_s
rooftops13152913rooftops
roosters83514653roosters
rooters74522933ro_oters
rosters73727533ro_sters
rotameters1245033rotameters
rotaries8315693rotaries
rotary92411303rota__ry
rotas54827723rota___s
rotate63320343rotat__e
rotated82715293rotat_ed
rotating92614553rotating
rotation81615453rotation
rotative11310343rotative
rotavirus1242873rotavirus
rotifers1136043rotifers
rotiform1344663rotiform
rotor55519733ro__tor_
rotos56027883ro__to_s
rotter64325463rot_ter_
rottes64524833rot_t_es
rousters84315653rousters
routers74822853ro_uters
roysters113610523roysters
rubatos9278643rubato_s
senators8312943senators
staters73922323_staters
stator64015473_stator_
tabors84517093__tabors
tatars64619793__tatars
taters64932193__taters
testators947323testators
titrators948353titrators
tomatoes1038603tomatoes
totters74618733tot_ters
trotters83310233trot_ters
tutors6912323__tutors
urinators947623urinators
viators102712013_viators
violators1246553violators
vitiators1246913vitiators

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.1731032896.0
2DLD Change Limit1461621757.73318901.1
3Display Results1751750.0632777.8
 (SQL Overall)1786911757.96922423.3
 
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.