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

255 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
visiters113740(None) 
visiter1038861visiter_
visitors1146431visitors
bisters93922602bis_ters
disinters1039702disinters
limiters10249322limiters
listers74026522lis_ters
misinters1138162misinters
misters93927502mis_ters
sisters73721572sis_ters
visited1168772visite_d
visitor1046202visitor_
visits9311422visit__s
viziers19336202vizi_ers
vomiters1337202vomiters
arbiters1038853arbiters
assisters936353assisters
asters65631603_as_ters
awaiters1146643awaiters
baiters94619303_baiters
basters94930303bas_ters
bister84922763bis_ter_
bistres94017213bis_tres
biters83925233__biters
bitters94920353bi_tters
blisters104015083blis_ters
bruiters10329133bruiters
busters94724123bus_ters
bustiers103810043bustiers
casters94729893cas_ters
cistern93310693cis_tern
cisterns10369563cis_terns
citers85022973__citers
costers94128303cos_ters
desirers939263desirers
diasters92913173diasters
diesters92513593diesters
dieters83216423di_eters
dilaters92513053dilaters
diluters9288103diluters
dimeters11411083dimeters
diopters1137683diopters
disasters1039143disasters
disinter9310673disinter_
dislikers14286423dislikers
disputers1236603disputers
disuniters11104723disuniters
dividers13257213dividers
diviners12308353diviners
dusters84918353dus_ters
easters75125683eas_ters
esters64627733_es_ters
exciters1736323exciters
festers104121393fes_ters
fibsters13126403fibsters
fighters15269393fighters
filisters1236993filisters
filters103816543fi_lters
finites10315923finite_s
fishers134714723fis_hers
fitters104517743fi_tters
fosters104220093fos_ters
fruiters11328173fruiters
gaiters83516533_gaiters
gasters85624283gas_ters
glisters93912603glis_ters
goiters84014433_goiters
gristers94013403gris_ters
heisters113413133heis_ters
hinters103719573hi_nters
hipsters13268783hipsters
hissers104112313his_sers
hitters104717583hi_tters
hoisters113513473hois_ters
hosiers104212633hosi_ers
igniters9126223igniters
inciters103210653inciters
inditers93311043inditers
insiders947753insiders
insisters997643insisters
inters64328043_i_nters
inviters11359633inviters
isomers9310043_isomers
issuers746123_issuers
jesters144118193jes_ters
jilters144211953ji_lters
jitters144314463ji_tters
justers143815723jus_ters
keisters123212043keis_ters
kibitzers2441863kibitzers
kiesters123310143kiesters
kilters113813593ki_lters
kissers114211293kis_sers
kiters105218583__kiters
klisters123910483klis_ters
lasters75627693las_ters
leisters83312823leis_ters
lifters104313773li_fters
lighters123111383lighters
limiteds11184543limiteds
limiter92710853limiter_
limites92915453limite_s
linters73822623li_nters
lispers94514323lis_pers
listees73416673lis_tees
listels74212433lis_tels
listens74014133lis_tens
lister64527253lis_ter_
liters65429873__liters
litters73422563li_tters
liviers104211073livi_ers
loiters74116613_loiters
lusters73921433lus_ters
masters94628923mas_ters
meisters103313843meis_ters
milters93619083mi_lters
ministers1139613ministers
minivers1337473minivers
minsters103813913minsters
minters93822463mi_nters
misalters1136903misalters
misavers1348053misavers
miscites12313783miscite_s
misdoers1137103misdoers
misenters1139523misenters
misers85025703mis__ers
misinfers1445473misinfers
misinter1038833misinter_
mislikers15317053mislikers
missteers1135913missteers
missteps12156143missteps
mister84728563mis_ter_
misterm114314513mis_term
misterms123711333mis_terms
mistier93418713mistier_
misusers10348073misusers
miters84328773__miters
musters94522493mus_ters
nesters74422783nes_ters
niters64624203__niters
orbiters1036593orbiters
osiers63412793_osi_ers
ousters74122773ous_ters
oysters103411683oys_ters
pasters94531733pas_ters
pesters93827093pes_ters
piasters102912803piasters
pinites9319533pinite_s
pishers123815753pis_hers
pissers95014753pis_sers
pistes85325633pis_te_s
pitiers93812653piti_ers
plaiters103512633plaiters
posters93927993pos_ters
rasters74629023ras_ters
reciters102613113reciters
residers93311883residers
resisters9310453resisters
resites74027793resite_s
resters74130403res_ters
ribiers9319753ribi_ers
righters122610703righters
rioters73615503ri_oters
risers64624783ris__ers
riskers114011993ris_kers
ritters74020613ri_tters
riveters11228153riveters
roisters83615543rois_ters
rosters73727533ros_ters
scimiters1345113scimiters
sifters103714783si_fters
sighters122510593sighters
simitars1046483simitars
sinters74024073si_nters
sister64421583sis_ter_
sitars65417593__sitars
sites56045433__site_s
sitters74221543si_tters
sivers95324153__sivers
sizers155215813__sizers
smiters93414363_smiters
suiters73618873_suiters
tasters74225643tas_ters
testers74124543tes_ters
tidiers8389773tidi_ers
tilters73315933ti_lters
tinters74221103ti_nters
tipsters10278503tipsters
titers64526403__titers
titters74219613ti_tters
twisters11268173twis_ters
ulsters72711983uls_ters
uniters73814173_uniters
unmiters1037073unmiters
variers103712663vari_ers
vaster94521023vas_ter_
vastier103613203vastier_
vaulters11206163vaulters
vaunters11327743vaunters
veilers103911823v_eilers
veiners104112523v_einers
veligers1237023veligers
velites103417303velite_s
venters103717723v_enters
verditers1344993verditers
verites103822253verite_s
vespers1239033ves_pers
vestees103513163ves_tees
vetivers1435163vetivers
vetters104016313v_etters
viators102712013vi_ators
victors123311173vi_ctors
viers85621953v__i_ers
viewers1337173vi_ewers
vilifiers1544563vilifiers
vinier93716743vini_er_
vinifera1443453vinifera
viniferas1542823viniferas
vintners1134573vintners
violaters1245953violaters
vipers114914533v__ipers
visages1138693visage_s
viscera1235083vis_cera
vises84427773vis__e_s
visions10311023visi_ons
visit8320963visit___
visitant1147363visitant
visitants1244763visitants
visiting1238393visiting
visive1257873visive__
visors92912223vis__ors
vistas94513273vis_t_as
vitamers1334673vitamers
vitiates112311413vitiate_s
vitiators1246913vitiators
vivers124717363v__ivers
vivider14265623vivider_
vivifiers1843673vivifiers
vizier184311023vizi_er_
vizirs18306713vizi__rs
voicers12348993v_oicers
voiders11279823v_oiders
vomiter1237953vomiter_
voters95017443v__oters
waisters113811523wais_ters
waiters104218623_waiters
wasters104026593was_ters
westers105221963wes_ters
winters103720473wi_nters
wishers133215213wis_hers
writers105513493_writers
xysters17307163xys_ters
zesters163517293zes_ters
zoisites1744973zoisite_s
zosters163015403zos_ters

Search took 10 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.1561145455.1
2DLD Change Limit1461622558.93616356.5
3Display Results2552550.0932741.9
 (SQL Overall)1786912559.18519454.7
 
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.