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

174 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
vibists125648(None) 
vibist11610581vibist_
biblists1236872biblists
cubists11359022cubists
ibises83610542_ibises
tubists9288322tubists
verists103613672verists
violists1137662violists
visits9311422visi_ts
ageists848493ageists
agists75713173_agists
ambits103713413ambi_ts
animists103010633animists
aorists74215833aorists
artists74215593artists
assists738473assists
aurists74615783aurists
autists73814853autists
aviarists1246613aviarists
basts75936933__basts
bemists113410703bemists
bests75932613__bests
biblist11310833biblist_
binits85716673bini_ts
bints76130183__bints
bises75435623__bises
bisks115416803__bisks
bits66148163__bi_ts
bitts75022593__bitts
busts75227693__busts
cambists1437023cambists
cists76624533__cists
civisms1436073civisms
cubisms13306883cubisms
cubist104214443cubist_
cubits103714033cubi_ts
debits94214503debi_ts
deists74916433_deists
delists84414173delists
desists83611723desists
dialists9411413dialists
diarists9410363diarists
dicasts1078703dicasts
digests93610613digests
digits84114533digi_ts
divests114510933divests
dixits144210313dixi_ts
egoists887073egoists
elitists848543elitists
enlists749393enlists
exists134710913_exists
feists94915313_feists
fideists1245543fideists
finises10312903finises
firsts95110923fi_rsts
fists85527543__fists
foists95413983_foists
gibbets12417723gibbets
giblets103210423giblets
gists66026193__gists
grists74716483_grists
habits113014653habi_ts
heists96814633_heists
hibiscus1541583hibiscus
hists86328373__hists
hoists95516023_hoists
holists104413963holists
ibices10398163_ibices
ibis66519583_ibi__s
idiots768643_idiots
insists739083insists
irises64221173_irises
joists134711033_joists
jurists14409123jurists
kibitz2177643kibi_tz
kists95822113__kists
legists899593legists
liaises7311053liaises
libelists1146953libelists
libidos1044653libidos
limits82514143limi_ts
lists56628693__lists
lutists73810273lutists
lyrists1036963lyrists
maists85817573_maists
midlists1137523midlists
midsts95510053mi_dsts
mists76633903__mists
mitises9315543mitises
monists93614783monists
nudists8356833nudists
obiisms1135673obiisms
obits74617553_obi_ts
oboists937903oboists
odists749853_odists
orbits84211443orbi_ts
papists112110453papists
pianists1049013pianists
pietists1038323pietists
pipits104713063pipi_ts
purists94014073purists
qiviuts1942893qiviuts
qubits173710353qubi_ts
racists92613323racists
rapists92510753rapists
relists73817053relists
resists74414923resists
ribiers9319753ribiers
riblets93412553riblets
riboses9310443riboses
riposts9279403riposts
sadists83310853sadists
schists1248543schists
sexists14267673sexists
shists96515113_shists
subsists1037993subsists
tanists7313653tanists
theists1039153theists
tibias839953tibi_as
tidbits1035183tidbi_ts
titbits935803titbi_ts
titlists837293titlists
tubaists1055103tubaists
tubist83013163tubist_
twists9549753_twists
typists1236173typists
valises103516263valises
vasts86423773v__asts
verisms123011253verisms
verist93823893verist_
versts93914733v_ersts
vests85325983v__ests
vibes104719953vib__es
vibrants1345913vibrants
vibrate122811523vibrate
vibrates132210613vibrates
vibrato12247383vibrato
vibratos13217483vibratos
vibrions1345093vibrions
vibrios1235803vibrios
vibrioses1443923vibrioses
vibriosis1443923vibriosis
vibrissa1362223vibrissa
vicious1239493vicious
vigias104110893vigi_as
vigils104210193vigi_ls
vikings15386623vikings
vilest9416843vilest_
viniest103216613viniest_
violets102210003violets
violist10312143violist_
virions1039873virions
viroses10310533viroses
virosis1039023virosis
viruses1039413viruses
visas84317653v__isas
vises84427773v__ises
visions10311023visions
visit8320963visi_t_
vista85416603v__ista
vistas94513273v__istas
vitalists1239223vitalists
vitiate103412953vitiate
vitiates112311433vitiates
vivisects1742083vivisects
viziers19336203viziers
vizirs18306713vizi_rs
volosts1036563volosts
vomits112610923vomi_ts
waists97415453_waists
whists124613813_whists
wists86728523__wists
wrists95415643_wrists
zibets1737743zib_ets

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.403443402.0
2DLD Change Limit1340271746.36021073.4
3Display Results1741740.0632761.9
 (SQL Overall)1786911746.82626178.0
 
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.