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

132 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
rostrate831384(None) 
prostrate11412481prostrate
castrate10313862castrate
costate94019272cost_ate
frustrate1245582frustrate
lustrate8310442lustrate
outrate72323182_outrate
postdate1139652postdate
postrace12310532postrace
prostate10314532prost_ate
prostrated1349422prostrated
prostrates12411992prostrates
restate73824882rest_ate
roseate7613452ros_eate
rostra6310932rostra__
rostral7311332rostra_l
rosulate8310902rosulate
rotate63320342ro_t_ate
apostate1049853apost_ate
arbitrate11137373arbitrate
aristate8312133arist_ate
bistate9313823bist_ate
borate85026153bo__rate
castrated1239513castrated
castrater1148523castrater
castrates11312673castrates
castrati1048643castrati
castrato1048523castrato
citrate92216803_citrate
contrite10318543contrite
costae85319683cost_a_e
cristate10310603crist_ate
cultrate10310873cultrate
disrate81418523dis_rate
distraite10611483distraite
doctorate1246783doctorate
estate64719763_est_ate
filtrate1148223filtrate
footrace1346413footrace
fossate10388603fos_sate
fosterage1344663fosterage
frostbite1443413frostbite
frustrated1444103frustrated
frustrates1345003frustrates
gestate83614073gest_ate
hastate10313913hast_ate
hostage113111233host_age
instate71616483inst_ate
lustrated1037963lustrated
lustrates939463lustrates
misrate91319143mis_rate
mistrace12312643mistrace
moderate11710993moderate
moschate1546583moschate
nitrate72017013_nitrate
notate63217863no_t_ate
obturate1077773_obturate
operate9615733_operate
orate55133303_o__rate
ostomate1049573_ostomate
ostraca937823_ostraca
ostraka1144833_ostraka
outate62923403_out_ate
outdate83016423_outdate
outrace92418553_outrace
outrage82616893_outrage
outrated92219313_outrated
outrates82421373_outrates
outrave102614413_outrave
overate10620963_overate
pastorate11411173pastorate
postage103214853post_age
postbase1246443postbase
postdated1346883postdated
postdates1248863postdates
postface1566123postface
postgame1345523postgame
posthaste1456603posthaste
postulate1169813postulate
prorate9418733pro__rate
prostates11314423prost_ates
protrade1148213pro_trade
recrate92621663r_ecrate
rectorate11411363rectorate
regrate82618663r_egrate
reiterate9412933reiterate
remonstrate13146403remonstrate
reoperate11410183reoperate
resinate8316773resinate
resituate948613resituate
reslate73520593res_late
resonate8513513resonate
restage83316193rest_age
restart7320033restart_
restarted10410053restarted
restarts8310873restarts
restated93120183rest_ated
restates83423433rest_ates
restrain8311703restrain
restrike1239673restrike
restrive11310923restrive
restrove1138963restrove
retrace91417343r_etrace
ristra6310713ristra__
ristras7311563ristra_s
roommate1244863roommate
rootage839053root_age
rosette7310373ros_ette
rosewater1245023rosewater
rostrally1246093rostrally
rostrum947213rostr_um
rostrums1046083rostrums
rotated82715293ro_t_ated
rotates72819773ro_t_ates
rotte54625933ro_t__te
rusticate1149033rusticate
sororate8411173sororate
state56237333__st_ate
strafe95215983__strafe
strake104017393__strake
strata63616283__strata
strath93216373__strath
strati63518903__strati
striate74218953__striate
substrate11178793substrate
tartrate899683tartrate
testate73916233test_ate
titrate72215573_titrate
tolerate8312323tolerate
tristate8311033trist_ate
unstate71916213unst_ate
upstate91610493upst_ate

Search took 10 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 Limit1461621329.51615359.6
3Display Results1321320.0632095.2
 (SQL Overall)1786911329.75218323.5
 
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.