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

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

75 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
rival8521650(None) 
nival84915771nival
rial45938101ri_al
rivals94213181rivals
riyal84413431riyal
arrival1037562arrival
arval86017012arval
binal75323822binal
bridal9511452bridal
civil103411932civil
dial55935072di_al
diva85920892diva_
divan96114842divan
divas95418582divas
drivel105110382drivel
final83922032final
frivol1235112frivol
kiva116516422kiva_
kivas124614742kivas
naval85315832naval
nidal65217112nidal
ogival1035872ogival
oval77119522_oval
pial65636712pi_al
pibal95217322pibal
pical95524372pical
pipal95118352pipal
primal104014622primal
ramal74622242ramal
ratal55025112ratal
ravel84621512ravel
real45750292r_eal
regal65023792regal
renal55929512renal
reveal94115062reveal
revel84423162revel
revival1337032revival
rhinal9510202rhinal
ria36745512ri_a_
rials55026672ri_als
rias45540602ri_as
ribald9209292ribald
rictal83113192rictal
riel46432392ri_el
rill45140912ri_ll
ritual6310622ritual
rivage1038842rivage
rivaled1138932rivaled
rivalry1354032rivalry
rive75537732riv_e
rived94825612rived
riven85121622riven
river85731692river
rives85336002rives
rivet85636362rivet
riyals94111082riyals
royal85014702royal
rugal65916092rugal
rural55821172rural
sial45938842si_al
sisal54217732sisal
tical76021492tical
tidal64516452tidal
trial54926352tri_al
tribal8611132tribal
trinal6516962trinal
trivial1038712trivial
urial54823022uri_al
urinal6614122urinal
vial76731102vi_al
vinal85725812vinal
viral86419592viral
vital84819672vital
viva106119102viva_
vivas114815022vivas

Search took 3 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 Filter178691538000.343520965.0
2DLD Change Limit53800751.68631909.8
3Display Results75750.0164687.5
 (SQL Overall)178691752.04587379.5
 
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.