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

197 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
rigour725802(None) 
rigor62714051rigo_r
rigours8206991rigours
vigour10256801vigour
giaour735362giaour
pigout9314612pigout
ragout7317182ragout
repour8310992repour
rigger85616712rigger
rigors72813712rigors
rimous8311912rimous
rugous739642rugous
rumour8127372rumour
vigor92612422vigo_r
vigours11285482vigours
algor6513053algo_r
amour75014853_amour
arbour84211323arbour
ardour74110893ardour
armour84411853armour
augur64311213aug_ur
bigger104315063bigger
bigos85020013bigo_s
bigot84828323bigo_t
bigotry1344513bigotry
bigots95015133bigots
bijou1458793bijou_
bijous1548043bijous
bijoux2253453bijoux
bugout9311863bugout
cigar8911793cig_ar
clour76617283_clour
colour85915083colour
crittur9315133crittur
detour778193detour
devour1076703devour
digger94616083digger
dimout9414243dimout
diseur738843diseur
dolour75710133dolour
dour56330433__dour
dugout8310363dugout
dyvour1393343dyvour
faitour1034883faitour
favour12438333favour
figure10258833fig_ure
flour84916453_flour
four76226863__four
friseur1033673friseur
gaur56723353__gaur
giaours834563giaours
gigolo836533gigolo
gigot74023073gigo_t
gigots83911953gigots
gigue71210673gig_ue
goer56827103__goer
gor47848263__go_r
gourd71011903__gourd
gout56646003__gout
higher134610893higher
honour94710863honour
hour75827313__hour
humour11116753humour
iglu510814783_iglu_
iglus6609933_iglus
incur72212253_incur
inpour837063inpour
jigger155313053jigger
labour84210933labour
liger65024463lig_er
ligure7279473lig_ure
liquor1534203liquor
lour45430683__lour
miaou7513083miaou_
miaous8511693miaous
minor74920063mino_r
muggur10325593muggur
nigger89713573nigger
nigher103612753nigher
odour64710473_odour
our36042893___our
pignus937953pignus
pignut9311573pignut
pigouts1037593pigouts
pilous84717753pilous
pious74621273pi_ous
pour611527473__pour
prior74316173pri_o_r
ragouts838533ragouts
rainout7314393rainout
ramous8417103ramous
rancour987133rancour
razor143012603razo_r
recoup10810373recoup
recur74116843r_ecur
redout71820253redout
regear73512743regear
regius7311923regius
reglue739703reglue
regnum957163regnum
regroup1095173regroup
reincur945133reincur
repours9310223repours
ribber103515493ribber
ribier84414223ribier
ribose839893ribose
ricer74726613ri_cer
richer114015043richer
rictus8379193rictus
ridder84015143ridder
rider65231303ri_der
ridgier937883ridgier
riever94811653riever
rifer84721983ri_fer
rifler94014263rifler
rig46748123rig___
rigged94517403rigged
riggers93613833riggers
right94430503rig_ht
righter113212373righter
righto104111093righto
rights104019333rights
righty135011833righty
rigid7913893rig_id
rigorous947373rigorous
rigs55137593rig__s
rimer75429243ri_mer
rimier83916263rimier
rimmer103516033rimmer
rimose8310593rimose
ringer74526053ringer
rinser64317213rinser
rioja1236303ri_oja
riot45947213ri_o_t
rioter64817283rioter
riotous739863riotous
riots54922013ri_ots
riper74328403ri_per
ripoff1436433ripoff
ripost83615003ripost
ripper103518653ripper
riser55431053ri_ser
risker105414493risker
risque15227453risque
risus54216393ri_sus
ritter63822413ritter
river85731693ri_ver
roar46328573r__oar
roger64521413rog_er
rogue66417533rog_ue
rotor55519733roto_r
roue45941743r__oue
roup66627693r__oup
rout46153283r__out
roux117419363r__oux
rubout8313553rubout
rufous948263rufous
rugger84414513rugger
rugola736293rugola
rugosa734563rugosa
rugose737283rugose
ruinous739753ruinous
rumor71011323rumo_r
rumours976363rumours
runout6414873runout
sapour83812373sapour
savour94110703savour
scour75315533_scour
siddur834573siddur
sieur5911893si_eur
sigher103813703sigher
siglum936563siglum
signer74015623signer
signor73510353signor
sour45935893__sour
stour54916743_stour
tabour84011313tabour
tenour62610733tenour
tiger65718633tig_er
tigon63914443tigo_n
tigons74112253tigons
tour45530373__tour
trigger9329153trigger
trigo65716053trigo__
trigon74513103trigo_n
trigons84312093trigons
trigos74214173trigo_s
tumour8137393tumour
urinous7310083urinous
valour93010373valour
vapour11378873vapour
velour9328763velour
vigors102911483vigors
vinous93914173vinous
visor82512833viso_r
vizor173010093vizo_r
your78623433__your

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 Filter1786911127160.216827273.1
2DLD Change Limit1127161978.19013762.6
3Display Results1971970.0762592.1
 (SQL Overall)1786911978.48221067.1
 
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.