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

117 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
riverine1131080(None) 
driveline1345352driveline
livering122012382livering
piperine122011832piperine
reverie103615162reveri_e
revering122918072revering
riverlike1644482riverlike
riverside1344912riverside
riveting12139442riveting
viperine13189712viperine
viverrine1544672viverrine
algerine9810283algerine
anserine8313083anserine
cicerone1247523cicerone
cinerin9313823cinerin_
cinerins10414103cinerins
citrine92514023ci_trine
covering142215723covering
coversine1459703coversine
dimerize2048113dimerize
diverge12347643diver_ge
diverging15226693diverging
diverse11429993diver_se
diverting142410333diverting
divine103514463div__ine
drivelines1444593drivelines
driveling1445763driveling
duvetine1245163duvetine
eserine7415903_eserine
ferine96422583__ferine
fevering152510083fevering
fiberize2246143fiberize
figurine1245603figurine
fivepins1644083fivepins
havering152211053havering
hovering151911143hovering
levering122212503levering
libertine1147433libertine
lierne638023li_er_ne
lifeline11167663lifeline
livening12248153livening
liveried1238733liveried
liveries11314373liveries
liverish1447863liverish
lovevine1444113lovevine
mitering113015403mitering
nidering10510483nidering
niterie7313743niteri_e
overing111918053_overing
overmine13313663_overmine
pelerine10313013pelerine
pipeline12149503pipeline
piperines131610693piperines
quivering2235873quivering
rareripe1045113rareripe
ravelin102211023ravelin_
raveling123414373raveling
ravelins113011603ravelins
ravening122611293ravening
ravine95522223rav__ine
redefine1238973redefine
refine95225693r__efine
reline65434353r__eline
repine85627813r__epine
rerise64325633r__erise
reserpine1147523reserpine
retine66237333r__etine
reveling123117083reveling
reverbing15248593reverbing
revere94621253rever__e
reverence14710163reverence
reverend12288853reverend
reverent112615093reverent
reveries112518513reveries
reverify1744813reverify
reverse103913743rever_se
reversing132611483reversing
reverting132315133reverting
revertive1548853revertive
rexine134719443r__exine
ridgeline11174723ridgeline
ripening1138573ripening
rivaling1239913rivaling
riven85121623rive__n_
river85731693river___
riverbank1842533riverbank
riverbed14245143riverbed
rivers94626543river__s
riversides1444323riversides
riverweed1643053riverweed
rivetting13256413rivetting
riviere1036373rivier__e
riving104521423riv__ing
rogering10310273rogering
serine65432673__serine
severing122013853severing
shivering1637333shivering
sideline91011093sideline
siderite9411363siderite
silvering1337923silvering
slivering1338083slivering
tiering8315253ti_ering
timeline1039243timeline
travertine1345413travertine
uterine7315193_uterine
venine93718433__venine
verite94323443__verite
versine102515173__versine
vicereine1444043vicereine
vitrine102511363vi_trine
viverrines1644133viverrines
vomerine1347683vomerine
wavering152410543wavering
wivern12409283wiver_n_
wiverns13366963wiver_ns
wolverine1554343wolverine
zibeline1946363zibeline

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 Limit1461621178.39017421.0
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.60920756.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.