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

288 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
viseed105310981viseed
listee64223062listee
vestee94319152vestee
visaed104110502visaed
visage1049082visage
vise75632672vis__e
vised95518762vis_ed
vises84427772vis_es
visive1257872visive
advisee11147153advis_ee
advisees12154133advisees
aisle55223193ais_le
aisled74516183aisled
aisles64721143aisles
aniseed839403aniseed
axseed1456993axseed
beseem1069083beseem
bigeye1236643bigeye
bireme10310143bireme
bise66437093bis__e
bisect10312873bisect
bises75435623bis_es
bisque17257843bisque
bister84922763bister
bistre83815023bistre
cisted95217523cisted
devisee113812713devis_ee
devisees12358283devisees
diene65720133di_ene
diesel74410403diesel
dieses75218693dieses
disced104914653disced
disease83213843disease
diseur738843diseur
diseuse83110713diseuse
dished114318713dished
dishes104622653dishes
disked125015763disked
disme85716243dis_me
dismes95617673dismes
dispel9310323dispel
dissed85220173dissed
disses75225963disses
disuse74012833disuse
evictee1248103evictee
fished134316313fished
fisher124917143fisher
fishes125221343fishes
fisheye1644773fisheye
fisted104218703fisted
frisbee12298513frisbee
frisee94217993fris_ee
frisees104411693frisees
fusee86224583fus_ee
fusees95416403fusees
giftee103512083giftee
hiree85427803hi_ree
hirees95117293hirees
hissed104114453hissed
hisser94713793hisser
hisses94719353hisses
histed104420243histed
isle45121703_is_le
isled64615993_isled
isles54220563_isles
islet54527553_islet
issei568573_issei
issue559213_issue
istle52214713_istle
jinnee13411573jinnee
kishke1254273kishke
kismet123414623kismet
kissed114412853kissed
kisser104212453kisser
kisses104217333kisses
lessee64116363lessee
libelee92510983libelee
lichee114017973lichee
liege65314433li_ege
lieve86315473li_eve
linseed838203linseed
lisente71210703lisente
lisle53916723lis_le
lisles63416283lisles
lisped94113423lisped
lisper84114433lisper
listed74322833listed
listees73416673listees
listel64214733listel
listen64816813listen
lister64527253lister
mestee84523883mestee
misate81222693misate
miscue10412223miscue
misdeed113211053misdeed
misdeem12217873misdeem
mise66043573mis__e
misease92713043misease
miseat82925703miseat
miser75430403mis_er
miserere1049273miserere
misers85025703misers
misery114113543misery
mises74740563mis_es
misfed124113023misfed
misfeed13389683misfeed
miskeep1536403miskeep
misled94719313misled
mislie83219153mislie
mismeet113215163mismeet
mismet103722373mismet
mispen10312173mispen
missed94423603missed
missel85216523missel
misses85130873misses
misset85028153misset
misted93625823misted
mister84728563mister
misuse83213643misuse
mustee83922103mustee
niece74814503ni_ece
nieve85613183ni_eve
nisei54214353nis_ei
niseis63512023niseis
oilseed835783oilseed
passee84522023passee
piece96717993pi_ece
pinene82915643pinene
pished124817063pished
pisher114317753pisher
pishes114722103pishes
pissed94816933pissed
pisser84416383pisser
pisses84525083pisses
piste75824603pis_te
pistes85325633pistes
prisere9310943prisere
resee54336333res_ee
reseed74823293reseed
reseek103813133reseek
reseen64318413reseen
resees63827483resees
rise45945233ris__e
risen54621883ris_en
riser55431053ris_er
risers64624783risers
rises55244043ris_es
risked115514633risked
risker105414493risker
risque15227453risque
rushee93818773rushee
see35772263__s_ee
seed55549483__seed
seek85935483__seek
seel45042983__seel
seem65438563__seem
seen46943123__seen
seep66540343__seep
seer45547043__seer
sees45361053__sees
seme65836653__seme
sene46848053__sene
sere46153473__sere
sickee124622223sickee
siege66718443si_ege
sieve84918843si_eve
signee73617233signee
siree55238813si_ree
sirees64624583sirees
sirree64017333sirree
sises55233833sis_es
sisses64520603sisses
sister64421583sister
skee85431473__skee
testee64323303testee
tisane6311573tisane
tissue637333tissue
triseme936543triseme
unseen62012623unseen
vakeel1335193vakeel
vase75629653vas__e
vases84626263vas_es
vaster94521023vaster
vee65750183v___ee
veep95325093v__eep
veepee11311483veepee
veer76229573v__eer
vees75439433v__ees
vegete1039483vegete
vendee105617263vendee
veneer94511693veneer
venene92912523venene
vesper1138083vesper
vessel937953vessel
vested104217353vested
vestees103513163vestees
viable111613773viable
vialed105112593vialed
vibe95124493vi__be
vibes104719953vi_bes
vice95732853vi__ce
viced115118183vi_ced
vices105725533vi_ces
vide85432753vi__de
video96014953vi_deo
videos104911373videos
vidette1167543vidette
vie65447633vi___e
vied86328633vi__ed
vier75428153vi__er
viers85621953vi_ers
vies75238623vi__es
view105917673vi__ew
viewed1345993viewed
viewer1237213viewer
views11489643vi_ews
viewy14518103vi_ewy
vile76139803vi__le
vilely1239443vilely
viler86324163vi_ler
vilest9416843vilest
villae95615383villae
vimen104114753vi_men
vine75643683vi__ne
vineal94814743vineal
vined95626153vi_ned
vinery124912593vinery
vines85137643vi_nes
vinier93716743vinier
violet92620923violet
viper105017303vi_per
vipers114914533vipers
vireo84816453vi_reo
vireos94212453vireos
vires84529683vi_res
virile9313433virile
virtue9358673virtue
vis66747613vis___
visa76323873vis__a
visaged1235683visaged
visages1138693visages
visard103910123visard
visas84317653vis_as
viscera1235083viscera
viscid1237473viscid
viscose1237863viscose
viscus11428503viscus
viseing11299163viseing
viselike1536923viselike
visible1236923visible
vising103915873vising
vision9311313vision
visit8320963vis_it
visited1168773visited
visiter1038863visiter
visits9311423visits
visor82512833vis_or
visored1138143visored
visors92912223visors
vista85416603vis_ta
vistaed1138013vistaed
vistas94513273vistas
visual938803visual
vitae84217633vi_tae
vitesse1044583vitesse
vittae93910993vittae
vittle94711753vittle
vivace1436553vivace
vive105426623vi__ve
vivers124717363vivers
vixen153010023vi_xen
vixens16286203vixens
vizier184311023vizier
wise75737343wis__e
wised95123343wis_ed
wisely122711713wisely
wisent93516343wisent
wiser85522803wis_er
wises85633193wis_es
wisest95016443wisest
wished134417513wished
wisher123617063wisher
wishes124920953wishes
wisped123411893wisped
wissed104114643wissed
wisses94619603wisses
wisted104120273wisted
yippee132810743yippee

Search took 6 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.1401276364.3
2DLD Change Limit1127162885.56320261.7
3Display Results2882880.1102618.2
 (SQL Overall)1786912885.81330739.9
 
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.