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

208 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
riviere103637(None) 
riviera1035071riviera
rivieres1136011rivieres
jivier16438612jivier_
livier97514592livier_
liviers104211072liviers
privier122910452privier_
revere94621252rev_ere
ribier84414232ribier_
ribiers9319752ribiers
rimier83916272rimier_
river85731692riv_er_
rivers94626542riv_ers
rivieras1143582rivieras
airier64619363airier_
aiver85725163aiv_er_
aivers94822323aiv_ers
brevier1237763brevier_
breviers1335933breviers
brinier93613473brinier_
caviare1238373caviare
civie103716353civi__e
civies114116443civie_s
dicier94416233dicier_
diver94827803div_er_
diverge12347643div_erge
divers105024963div_ers
diverse11429993div_erse
divert103922813div_ert
divide113410893divi_de
divider12278953divider_
dividers13257213dividers
divine103514463divi_ne
diviner11369883diviner_
diviners12308353diviners
driver104714493driv_er_
drivers114412793driv_ers
envier939673envier_
enviers1036993enviers
fiver116024943fiv_er_
fivers124420923fiv_ers
giver94921203giv_er_
givers104817713giv_ers
grimier103210433grimier_
gripier103210323gripier_
icier74313753_icier_
inhere9313713_inhere
ivied94710523_ivie_d
ivies84215763_ivie_s
jiver155119053jiv_er_
jivers164515643jiv_ers
jiviest1738113jiviest
levier94013873levier_
leviers103510343leviers
limier83518723limier_
linier64423793linier_
liver85132963liv_er_
livered113111633liv_ered
livers94927823liv_ers
livery124910903liv_ery
livre85613253liv__re
livyer12426293livyer_
livyers13365903livyers
mirier83918363mirier_
mitier83620673mitier_
oilier64417233oilier_
pinier84024693pinier_
pipier104913983pipier_
pitier84019823pitier_
pitiers93812653pitiers
premiere12249233premiere
pricier113313113pricier_
prisere9310943pri_sere
privies122414263privie_s
priviest132310313priviest
privilege1552543privilege
racier85120973racier_
rainier71614263rainier_
rapier84019993rapier_
rapiered1136053rapiered
rapiers95012873rapiers
raver85631493rav_er_
ravers94628183rav_ers
ravine95522223ravi_ne
refire95419473refi_re
rehire95415863rehi_re
reifier103414523reifier_
reifiers11309843reifiers
reiver95318293reiv_er_
reivers105117083reiv_ers
relier65826183relier_
reliers75519213reliers
relieve105010693relieve
retire64927013reti_re
retiree75019083retiree
reverb113912573rev_erb
revered112819333rev_ered
reverer103815833rev_erer
reveres103621343rev_eres
reverie103615163rev_erie
revers94529633rev_ers
reverse103913743rev_erse
revert93529113rev_ert
revery124014213rev_ery
review1238693revie_w
reviewed1534823reviewed
reviewer1434133reviewer
reviews1335533reviews
revile94921613revi_le
reviler104314973reviler_
revilers114011693revilers
revise94019743revi_se
reviser104114663reviser_
revisers113511933revisers
revive124914823revi_ve
reviver134411373reviver_
revivers14389633revivers
rewire95421413rewi_re
ribber103515493ribber_
ribbers113913183ribbers
ribbier1137593ribbier_
ricer74726613ri_cer_
ricers84120993ri_cers
richer114015043richer_
ridder84015143ridder_
ridders93612493ridders
rider65231313ri_der_
riders74123903ri_ders
ridgier937883ridgier_
riever94811653riever_
rievers104311453rievers
rifer84721983ri_fer_
rifler94014263rifler_
riflers103512203riflers
riflery13345803riflery
rigger85616713rigger_
riggers93613843riggers
rilievi10372853rilievi
rilievo10373463rilievo
rimer75429243ri_mer_
rimers84522553ri_mers
rimfire1243793rimfire
rimiest93215853rimiest
rimmer103516033rimmer_
rimmers113812883rimmers
ringer74526063ringer_
ringers83922953ringers
rinser64317213rinser_
rinsers73815743rinsers
rioter64817283rioter_
rioters73615523rioters
riper74328403ri_per_
ripieni944113ripieni
ripieno944133ripieno
ripper103518653ripper_
rippers114115033rippers
riser55431053ri_ser_
risers64624783ri_sers
risible937923risible
risker105414493risker_
riskers114011993riskers
riskier1138423riskier_
ritter63822423ritter_
ritters74020623ritters
ritzier16297203ritzier_
rivage1038843riv_age
rivalry1354033rivalry
rive75537733riv___e
rived94825613riv_e_d
riven85121623riv_e_n
riverbed14245143riv_erbed
riverine11310803riv_erine
rives85336003riv_e_s
rivet85636363riv_e_t
riveted11258573riv_eted
riveter10208753riv_eter
riveters11228163riveters
rivets94417113riv_ets
riving104521423rivi_ng
roilier7311523roilier_
ropier84118813ropier_
rosier64221273rosier_
rover85527373rov_er_
rovers95423523rov_ers
rubier84814743rubier_
rulier65016353rulier_
severe94016083sev_ere
sincere9310553sincere
siver85728613siv_er_
sivers95324153siv_ers
sizier1514813393sizier_
tidier73515113tidier_
tidiers8389773tidiers
tinier63622233tinier_
vier75428163__vier_
viers85621953__viers
vinier93716743vinier_
vivers124717363viv_ers
vivider14265623vivider_
vizier184311023vizier_
viziers19336203viziers
wavier124613083wavier_
wilier93217073wilier_
winier94522453winier_
wirier94215553wirier_
wiver115924513wiv_er_
wivern12409283wiv_ern
wivers125320803wiv_ers

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.403443402.0
2DLD Change Limit1340272087.37618170.7
3Display Results2082080.0802600.0
 (SQL Overall)1786912087.85922737.1
 
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.