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

154 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
ragtime103616(None) 
ragtimes1135821ragtimes
bigtime1235752bigtime
daytime1344782daytime
pastime114611972pastime
ratine65131822ra_tine
ratite65022422ra_tite
regime95313942reg_ime
retime85321802r_etime
wartime1237742wartime
active11313743_active
agatize1739833_agatize
aggie73415013_aggi_e
agile65122263_ag_ile
agnize16329563_agnize
airtime948063airtime
anime75423203_a_nime
anytime1246043anytime
attire62412383_attire
baggie102912193baggi_e
baglike14338943baglike
bagpipe1453113bagpipe
baptise1139553baptise
baptize2036983baptize
bastile9313913bastile
bawtie113812143bawti_e
bedtime1236973bedtime
begrime1276553begrime
betime105914833_betime
brattice1245693brattice
captive1438973captive
cattie85221023catti_e
centime114513033centime
dative10311813da_tive
dautie72914703dauti_e
dawtie103011093dawti_e
daytimes1434483daytimes
dragline1036843dragline
dreamtime1442343dreamtime
ergative1238973ergative
fragile1147843frag_ile
glime85620193__glime
gratine84719193gra_tine
grime85021323__grime
hagride1237553hagride
halftime1643313halftime
hogtie102711773hogti_e
intime81014273_intime
lattice938433lattice
longtime1144363longtime
magpie1139093magpi_e
maritime1247383maritime
mealtime1245123mealtime
meantime1245983meantime
mistime11312613mistime
native9613013na_tive
onetime937623onetime
optime1079353_optime
pantie84326473panti_e
pantile93918483pantile
partite9317133partite
pastie85525523pasti_e
pastimes123611903pastimes
patine85328123pa_tine
pattie84020963patti_e
playtime1544793playtime
practice1438733practice
practise12310143practise
raceme1039733ra_ceme
radome9511873ra_dome
rafting113815753rafting
raftsmen1343953raftsmen
rage55742353rag___e
ragee65432663rag__ee
raggee84217603rag_gee
raggies93214733raggies
ragging103516683ragging
raggle83712883rag_gle
ragi56032283rag_i__
raging85126433rag_ing
ragis66325603rag_i_s
ragmen93712183rag__men
ragtag836643ragt_ag
ragtags935373ragtags
ragtop936683ragt_op
ragtops1035453ragtops
raise54828053ra__ise
ralline73518413ralline
ramie75027823ra_mi_e
rampike1536603rampike
ramtil8311033ramti_l
ramtils938413ramtils
ranpike1335933ranpike
ranting84025413ranting
raphide13138073raphide
rapine85023083ra_pine
rapture937393rapture
rate45458763ra_t__e
rathe85821923ra_t_he
ratify122610043ra_tify
ratines75328583ra_tines
rating74938703ra_ting
ratio55227583ra_ti_o
ration64226013ra_tion
ratios64922673ra_tios
ratites74920683ra_tites
ratlike113912353ratlike
ratline74517803ratline
rattier74015593rattier
ratting83822363ratting
rattish10510823rattish
rattle64717613ra_ttle
ravine95522223ra_vine
rawhide14134973rawhide
raylike14269253raylike
reactive13310473reactive
regimen104411573reg_imen
regimes104514743reg_imes
regive104814323reg_ive
reptile93914083reptile
restive10315933restive
retie55735303r_eti_e
retile65929673r_etile
retimed104714653r_etimed
retimes95020173r_etimes
retine66237333r_etine
retire64927013r_etire
rime65138893r___ime
riptide1036893riptide
routine72615903routine
ruglike1236283ruglike
rutile65217683r_utile
saltie63422433salti_e
saltine75018563saltine
saltire73113043saltire
santimi938793santimi
santims9312603santims
santimu938563santimu
satire63218003sa_tire
septime1138803septime
stime76521803__stime
tactile9310613tactile
taglike12278913taglike
tagline82412453tagline
tagmeme1243353tagmeme
tattie64817513tatti_e
teatime9310083teatime
time66235023___time
tractile10311073tractile
tractive13310043tractive
uptime1067673_uptime
vagile10310543vag_ile
wagsome1345213wagsome
wartimes1336963wartimes

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.406440125.6
2DLD Change Limit1340271546.64020184.8
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.