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 “outrival” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

70 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
outrival114531(None) 
outrivals1243891outrivals
outrivaled1443242outrivaled
arrival1037563_arrival
atrial65418943_atri_al
burial84117623bu_ri_al
corrival1346143corrival
curial84019153cu_ri_al
datival1135583dat_ival
deprival1444603deprival
detrital946573detrital
doctrinal1243903doctrinal
estival1036323est_ival
iatrical1049273iatrical
lubrical12116093lubrical
metrical12311583metrical
nonrival1146613nonrival
nontribal1145863nontribal
nontrivial1354863nontrivial
nutria639903nutri_a_
nutrias739813nutri_as
octaval1243583oct_aval
ogival1035873o__gival
optical1149863opt_ical
optimal1145783opt_imal
outcavil1343833outcavil
outdrive1236883outdriv_e
outdriven1344313outdriven
outdrives1346693outdrives
outgive11199253outgiv_e
outgiven12255433outgiven
outgives12218623outgives
outkill1136553outki_ll
outlive102513033outliv_e
outlived12269583outlived
outliver11268783outliver
outlives112511763outlives
outran63218883outr__an
outrave102614413outrav_e
outraved122511923outraved
outraves112313833outraves
outread82811093outr_ead
outride82615673outri_de
outrider92410553outrider
outrides92414993outrides
outrig72812843outri__g
outright1248743outright
outrigs82811253outri_gs
outring84021013outri_ng
outrings92811053outrings
outrivaling1543753outrivaling
outrivalled1551733outrivalled
outroar739513outr_oar
outroll749303outr_oll
outtravel1244203outtravel
outwill1037323outwi_ll
ovarial1037613ovari_al
retrial7615553retri_al
retrieval1243283retrieval
rival85216503___rival
rubrical1296093rubrical
survival1443923survival
trial54926353__tri_al
tribal8611133__tribal
trinal6516953__trinal
trivial1038713__trivial
turrical1046203turrical
tutorial847833tutori_al
urial54823023_u_ri_al
urinal6614123_u_rinal

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162708.54617103.0
3Display Results70700.0302333.3
 (SQL Overall)178691708.74920424.2
 
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.