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

157 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
voyeurs133242(None) 
voyeur1232861voyeur_
foyers125413132foye_rs
oyers87620882_oye_rs
poseurs9378292poseurs
toyers95516332toye_rs
voguers11356692voguers
vomers115614942vome_rs
voters95017442vote_rs
vowers124317182vowe_rs
voyageurs164742voyageurs
voyeurism1751982voyeurism
auteurs7137503auteurs
avowers1336333avowe_rs
boners84825433bone_rs
borers85122683bore_rs
bowers115523703bowe_rs
bowyers15438733bowye_rs
boxers155013483boxe_rs
boyars115611983boy_ars
buyers114511003buye_rs
coders95426983code_rs
coheirs1236753coheirs
coleus86818273coleu_s
colours95913443colours
comers105328083come_rs
concurs11311473concurs
cooers84324563cooe_rs
copers104629843cope_rs
corers85231073core_rs
covers114627963cove_rs
cowers114625533cowe_rs
coyer105222843coye_r_
coypus13389303coypu_s
diseurs839403diseurs
doers65225713do_e_rs
dogears937513dogears
dolours8438823dolours
dopers95522483dope_rs
dosers75723633dose_rs
doters74423913dote_rs
douceurs1142793douceurs
dowers104523293dowe_rs
doyens104810223doye_ns
dozers164815423doze_rs
dryers10449273drye_rs
dyers96617133_dye_rs
evokers14386793evoke_rs
eyers86521333_eye_rs
flyers125712803flye_rs
fours85521493fo__urs
foyer116416553foye_r_
fryers125710973frye_rs
goers65520253go_e_rs
gofers104711513gofe_rs
gomers94116883gome_rs
goners74420173gone_rs
hayers124415943haye_rs
hoers85724923ho_e_rs
homers114821973home_rs
honers94324973hone_rs
honours10339373honours
hopers114222973hope_rs
hosers95223963hose_rs
hours85422393ho__urs
hovers124320253hove_rs
jokers175511193joke_rs
joyous16276763joyou_s
layers93921183laye_rs
loners64225813lone_rs
lopers84424143lope_rs
losers65123583lose_rs
lours55125293lo__urs
lovers94223433love_rs
lowers94624923lowe_rs
mohurs1135933mo_hurs
mopers104220373mope_rs
movers115117193move_rs
mowers113219403mowe_rs
noters64021003note_rs
occurs10136553_occurs
odeums9367313_odeums
odours7418253_odours
oleums8358783_oleums
omers76923193_ome_rs
ours47237563_o__urs
overs85224793_ove_rs
oyer75927653_oye_r_
oyes74940133_oye__s
oyezes1835053_oyezes
payers114621823paye_rs
plyers114912983plye_rs
pokers124617923poke_rs
polers84225643pole_rs
posers84223973pose_rs
poseur8419403poseur_
pours74623183po__urs
powers113822323powe_rs
poyous112911623poyou_s
pryers115012243prye_rs
rogers74517913roge_rs
ropers84325903rope_rs
rovers95423523rove_rs
rowers94924573rowe_rs
sayers94221593saye_rs
shyers124712203shye_rs
sieurs659043_sieurs
sobers85218863sobe_rs
soleus64615613soleu_s
sours55230503so__urs
sowers94923443sowe_rs
tokers104818893toke_rs
toners64128003tone_rs
topers85025323tope_rs
toters65026363tote_rs
tours55325893to__urs
towers94423673towe_rs
toyer84521553toye_r_
tuyers94612563tuye_rs
twyers12497413twye_rs
tyers86220053_tye_rs
valours10248743valours
valuers10328943valuers
vapours12277463vapours
veers84521363v__eers
velours10278083velours
veneers103710293veneers
vexers165210403vexe_rs
viers85621953v_ie_rs
vigours11285483vigours
vipers114914533vipe_rs
vivers124717363vive_rs
voces105918053voce__s
vodouns1134763vodouns
vodous1038603vodou_s
voduns1035053vo_duns
voes75432823vo_e__s
voguer10468403voguer_
vogues104011923vo_gues
voicers12348993voicers
voiders11279823voiders
volery1237873vole_ry
voles86234043vole__s
vomer105517383vome_r_
voter85121053vote_r_
votes84627083vote__s
vowels124410483vowe_ls
vower115220793vowe_r_
voyagers1532813voyagers
voyages1435703voyages
voyageur154853voyageur_
voyeurisms1852033voyeurisms
wooers93712443wooe_rs
years84527673__years
yeuks125110093__yeuks
yours85217883__yours
zoners155115993zone_rs

Search took 7 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.406440125.6
2DLD Change Limit1340271575.79623124.1
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.26528522.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.